You can reduce this only by improving your network. This delay caused by data transfer from SQL Server to ODBC, and than from ODBC to VFP. Some ODBC settings might help too, however, I don't know exactly what to configure (my application worked ok with default settings). If you have large result set - this is also a cause of delay.

>I run a query against a sql server database using SQLEXEC with the following syntax;
>
>SELECT note_nr FROM notes WHERE note LIKE '%TEST%'
>
>It takes big part of a minute before vfp comes back with a cursor containing twenty or so records. If I run the same query using the SQL Server query tool the response is almost immediate.
>
>Is there anyone out there knowing how to resolve this problem?
>You'd make my day !
>
>Wilco.