| Subject | When AutoFetchAll = false, bad speed perfomance...how to get max. speed? |
|---|---|
| Author | coderefectory |
| Post date | 2006-03-05T23:46:24Z |
Hi!
I have DSL network connection, speed 512kbit/s download and 128kbit/s
upload, Open VPN...remote database!
I tried to set AutoFetchAll = false, FetchWholeRows = false,
AutoFetchFirst = true...it works!
But I'm not satisfied with scrolling and searching speed, especially
on master detail relations.
When I set AutoFetchAll = TRUE (my common seting) I must wait, until
pop-up window "Feching Query Results...Row#123..." disappear.
After fetching all rows speed is very good!
My question is how to "on easy way" get the same speed with
AutoFetchAll = FALSE?
I have DSL network connection, speed 512kbit/s download and 128kbit/s
upload, Open VPN...remote database!
I tried to set AutoFetchAll = false, FetchWholeRows = false,
AutoFetchFirst = true...it works!
But I'm not satisfied with scrolling and searching speed, especially
on master detail relations.
When I set AutoFetchAll = TRUE (my common seting) I must wait, until
pop-up window "Feching Query Results...Row#123..." disappear.
After fetching all rows speed is very good!
My question is how to "on easy way" get the same speed with
AutoFetchAll = FALSE?