Jim,

Just make sure you use the nofilter statement in your SQL query.

I did just discover that if you ran a query on one instance of VFP in about 60 secondsm you can run the same query in a fraction of this time in another instance of VFP.

It seems that the buffers of the intermediate resultsets used internally by the SQL-SELECT command are maintained by the OS.