> However, RefreshKeys will be faster because, if your KeyLinks are good,

IBO

> can fetch just the new rows and update the dataset. With bad KeyLinks, RK
> won't work.

My KL are good, I expect this to help at least by the smaller datasets. I
hope I'll find a solution how to modify my application in the other cases.
Thanks a lot
Andreas

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, April 21, 2004 12:20 PM
Subject: Re: [IBO] Please help - can CommitAction := caFetchAll solve it?


> At 12:05 PM 21/04/2004 +0200, you wrote:
> >Thanks Helen, does that probably mean that caRefresh would do the same as
> >TIBOTable.RefreshRows? If so I probably can't use it, because with a
table
> >with large record count my application became unusable with RefreshRows
> >because of very low performance.
> >
> >On other tables it can be usable, which shall I use ten, caRefresh or
> >caRefreshKeys?
>
> Large datasets are *not* a good idea for editing!!! (Actually, they are
> not a good idea for *anything*. That's why we have a **query**
language.).
>
> However, RefreshKeys will be faster because, if your KeyLinks are good,
IBO
> can fetch just the new rows and update the dataset. With bad KeyLinks, RK
> won't work.
>
> Helen
>
>
>