Mark,
>I'm not sure what you mean by the memory.
Would you describe the the server?
> ...but I can't believe the performance would be so much less.
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?
-Mike