John, please, if you have a pecuniary interest in recommendations you make, you should say so.
Here you are, with an "MVP" in your sig, pushing your own product like that. I think that's ethically borderline, don't you?
**--** Steve
>Check the indexes on your backend. If you are using SQL Server, do you have a clustered index? Does your search criteria match an index? And finally, make sure the server hardware is adaquate.
>
>Another thing to check: are you minimizing the number of records you need to fetch from the server?
>
>Lastly, Go to
www.redmatrix.com and check out dataclas. If you find yourself in a situation where you can ditch the RV's, try Dataclas.
>
>Good luck!
>
>
>
>>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.