View Issue Details

IDProjectCategoryView StatusLast Update
0003322SymmetricDSNew Featurepublic2019-04-24 16:54
Reporterwoehrl01 Assigned To 
Prioritynormal 
Status newResolutionopen 
Summary0003322: Improve reload performance by caching rarely changing tables
DescriptionSome 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.
Tagsperformance

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2017-11-27 08:24 woehrl01 New Issue
2019-04-24 16:54 elong Tag Attached: performance