>>So what's your opinion now? Still think IN is faster/better performance?
>
>Well, I asked you for the results. :) So, no, I'm not sure it is faster in any condition. :) Although, I would try to make the test (if possible) with all tables on local drive.
Yes, I do want to try running these tests with all tables on a local drive. I just normally go for the "across the network" tests firsts because in my environment I've seen a big difference, with network response being not so good when local performance seems fine. (Users are never accessing local data once code goes into production)
>
>Also, extremly important: close and reopen VFP between each 2 SELECTs in order to get accurate results. VFP is optimizing from one SELECT to another when this is possible. Since the SELECTs are on the same dbfs, it's almost sure some optimizations are done as you pass from one SELECT to another.
>
I seen that when I first started, thats why I alternated between the 4 queries. But good point, I will try this first and let you know if I see any different results.
>Thanks for the results and I'd be interested to hear about any new results you may have.
>
>Vlad
Oh you're quite welcome, and thank you for the insights!
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos