Dear DevArt;
For complex database desktop application (multi-tables, multi master-detail-subdetial relation … etc) , what the preferred mode to used Cached or NonCached from your expert point of view … ??
Hope to get a detailed answer not a briefed one …
Best Regards,
Ahmed Hijazi P. Eng.
Cached Mode vs NonCached Mode ??
Hello,
Setting CachedUpdates to True enables updates to a dataset (such as posting changes, inserting new records, or deleting records) to be stored in an internal cache on the client side instead of being written directly to the dataset's underlying database tables. When changes are completed, an application writes all cached changes to the database in the context of a single transaction.
Cached updates are especially useful for client applications working with remote database servers. Enabling cached updates brings up the following benefits:
- Fewer transactions and shorter transaction time;
- Minimized network traffic;
- Ability to use the BatchUpdate mode to increase performance with inserting and updating large volumes of data.
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 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.
Setting CachedUpdates to True enables updates to a dataset (such as posting changes, inserting new records, or deleting records) to be stored in an internal cache on the client side instead of being written directly to the dataset's underlying database tables. When changes are completed, an application writes all cached changes to the database in the context of a single transaction.
Cached updates are especially useful for client applications working with remote database servers. Enabling cached updates brings up the following benefits:
- Fewer transactions and shorter transaction time;
- Minimized network traffic;
- Ability to use the BatchUpdate mode to increase performance with inserting and updating large volumes of data.
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 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.