You may want to check how long the same query takes outside VFP. For example, run the query from SQL Server Query Analyzer tool. This will give you an idea on how long the query takes by itself without any VFP overhead.
>Hi all,
>How to speed up a SQL remote view when calling out from VFP ?
>I have tried to using the fetch mode. It can return the control
>so fast and the program can be opened quickly. But when I issue
>tableupdate(.t.) command, it return an error, it is the connection
>is busy. I know all records of the table is being fetch at the
>background. Thus I can only update the table after the fetch is
>completed. And if I interrupt the fetch process, the table can't
>be updated. When the table is so large, the fetch time is so long.
Hector Correa