Show TOC

Caching ModeLocate this document in the navigation structure

Use

In general, data is displaced from the data cache in chronological order. There may be certain situations though where it makes sense to keep data from specific tables in the data cache for a longer time.

The caching mode enables you to specify when data from a specific table is displaced from the data cache. Data that is to be kept for a longer time is held in a special area of the data cache, the pin area.

Caching Mode

Description

Default

Data from the table is displaced from the data cache according to the LRU (least recently used) list.

Keep

Data from the table (all values including LOBs and index data) is held in the pin area of the data cache for as long as possible.

If the pin area is full, the least recently used data from the pin area is moved to the end of the default LRU list and then displaced according to the normal chronological mechanism.

This caching mode is particularly suited for tables that are accessed very frequently.

Replace

Data from the table (all values including LOBs and index data) that is read into the data cache is removed from the data cache quickly.

This caching mode is suited for tables which are only accessed very infrequently.
More Information