Hi Renoir,

Are you running Windows NT/2000/XP? In this case you really should get FileMon from Sysinternals (http://www.sysinternals.com/ntw2k/utilities.shtml). It monitors all file activity including read and write operations. Maybe the log explains what happens.

Also, make sure you check SYS(3050). This buffer is used for caching all temporary data. If VFP needs more memory than you allow, VFP starts swapping to its temp directory. If this happens to be on the server or on a slow drive, this could slow down the query considerably.

Christof