View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0003322||SymmetricDS||New Feature||public||2017-11-27 03:24||2017-11-27 03:24|
|Target Version||Fixed in Version|
|Summary||0003322: Improve reload performance by caching rarely changing tables|
|Description||Some tables can be huge, with lots of binary columns and they change rarely. The fetching of the data on a reload could lead to a big stress on the db server if it has to convert all the binary fields. |
The following PR adds a feature to allow to define on the trigger_router level. If thus tables should be cached in the staging area. The first time it fetches the table, it loads it from the database and writes all the data at the same time to a new staging area. The second time it fetches the data purley from that cache.
If new data flows through the data router it clears those caches.