S
Stefan Drissen
Guest
We have a lazy generic temp-table cache for most master data. The temp-table has something like table / field / value as fields. Another temp-table contains meta-data and query handles. This was created a long time ago (even pre-appserver) when number of database reads was our only solid performance metric. The 15 second life limit was added while moving to appserver to reduce stale data issues. Later on we also added temp-tables for generally static master data - these are filled / refreshed when needed based on a timestamp of last update in the database. With lazy I mean that data is only fetched when first required.
Continue reading...
Continue reading...