>I'm assuming you're seeing the disk thrash on the workstation, not the MySQL server.

Yes

>- Are you running as Administrator or equivalent on the XP box?

Yes

>- Are you sure you don't have a virus?

Not totally, but fairly sure - there is an up to date virus checker, and no evidence of a virus

>- Have you had Performance Monitor up while you ran the query?

No - but we have had Task Manager and not noticed any unusual or intensive processes during the disk thrash.


>>I am encountering an extremely strange problem. After executing a small (3 row) Sqlexec query on a remote MySql database, the query is completed immediately, but the disk then thrashed for up to two minutes before continuing to the next line of code.
>>
>>What I have ruled out:
>>1. Slow connections - I can see the temporary cursor being created immediately in the VFP temp path
>>2. Virus checker - I can do a local query, see the cursor created, but no disk thrash
>>3. Remote Database/Syntax: I have the same command running on many other PCs querying the same database
>>4. ODBC - I have tested various ODBC versions
>>5. Low disk space/memory - the PC is new and has plenty of spare resources
>>
>>Problem Environment: Windows XP with full VFP5 installed, and the SqlExec tested with both VFP5 and VFP6 runtime files.
>>
>>I suspect the problem is something to do with VFP5 being installed, but I can't see any odd settings. Any ideas?
>