| Subject | Re: [IBO] When AutoFetchAll = false, bad speed perfomance...how to get max. speed? |
|---|---|
| Author | Dany M |
| Post date | 2006-03-06T11:47Z |
coderefectory wrote:
requested in the underlying SELECT that are actually shown in the grid,
try turning *on* the FetchWholeRows.
IMO this flag will not disable the keyFetch-intelligence of IBO it will
merely fetch the whole row immediately for "visible" records. But I'm
not a 100% sure of this.
Anyway - give it a try.
128Kb/s is in my opinion rather on the low side of bandwith but it
should work.
/Dany
> Hi!Depending on how wide the row is and how much of the information
> 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.
requested in the underlying SELECT that are actually shown in the grid,
try turning *on* the FetchWholeRows.
IMO this flag will not disable the keyFetch-intelligence of IBO it will
merely fetch the whole row immediately for "visible" records. But I'm
not a 100% sure of this.
Anyway - give it a try.
128Kb/s is in my opinion rather on the low side of bandwith but it
should work.
/Dany