>I have an application that uses remote views. The connection properties is set to pull 100 records per batch.
>
>My main problem is that on large queries the user may try to perform another option while records are still being pulled in the background. This of course generates the connection too busy error. It also seems that the query does not pull all the records unless you scroll down in the grid.
>
>I'd rather not change the connection to pull 'All' at once because it's possible there could be many. I also suppose I could use a seperate connection for the other operations on the form, but I'd like to keep the connection count down if possible.
>
>Anyone got suggestions on the most appropriate way to handle this scenerio.
>
>Greg
Hi Greg,
Set 'FetchAsNeeded' property to .F. to enable background fetch during idle time.
Also, if you are using VFP8, you may take advantage of the new connection sharing. In conjunction with 'AllowSimultaneousFetch' set to .T., it allows to fetch multiple result sets simultaneously using single ODBC connection (it might have performance penalty though).
Thanks,
Aleksey.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement