[fdo-users] How to boost ISelect and IUpdate command performance

Jonio, Dennis (Aviation) DJonio at miami-airport.com
Tue Nov 30 10:54:53 EST 2010


Maybe I don't understand fully the need to do a one-at-a-time query vs.
a set-at-a-time. Does your provider support "IN"? (UFID IN
(XXXX,XXXX,XXXX)) or even (UFID = {0} OR UFID = {1}). 

It would seem to me that iterating a reader, even multiple times, would
be significantly faster than hundreds of thousands of queries. 
r,
dennis


More information about the fdo-users mailing list