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.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.