Mike,
Well, I tried it both ways, with no real difference. To eliminate any caching, I rebooted before each attempt. Both queries were run on the table located on the server machine, so my guess is that VFP has to pull the file across the network in either case.
Mark
>When you run the test with VFP, did you use the NOFILTER clause?
>
>SELECT * FROM table WHERE column = value NOFILTER
>
>If not, would you please?
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.