--- In IBObjects@y..., Daniel Bertin <daniel@d...> wrote:

> Hi all
>
> I'm using IBO, firebird6, delphi5 and am wondering about when to

use cached

> updates, with a table component, and when not to use?
>
> is there speed or other issues? could someone enlighten me on this

subject

> please
>
> thanks in advance
> Daniel
>
>
>
> _______________________________________________
> Delphi-DB mailing list
> Delphi-DB@e...
> http://www.elists.org/mailman/listinfo/delphi-db

Clipped from TQuery.CashedUpdates help:

When cached updates are enabled, updates to a dataset (such as
posting changes, inserting new records, or deleting records), are
stored in an internal cache on the client machine instead of being
written directly to the dataset's underlying database tables. When
changes are complete, an application writes all cached changes to the
database in the context of a single transaction.

Cached updates are most useful to client applications in two-tiered
applications. The main benefits of enabling cached updates are:

• Fewer transactions and shorter transaction times.
• Minimization of network traffic.

The potential drawbacks of enabling cached updates are:

• Other applications can access and change the actual data on
the server while users are editing local copies of the data,
resulting in an update conflict when cached updates are applied to
the database.
• Other applications cannot access data changes made by an
application until its cached updates are applied to the database.

pfewww