Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

SPECIAL_CACHE_FILE

SPECIAL_CACHE_FILE <datafilename>#<bytes to cache>

Note: This keyword was removed in V11 and later (notice this impacts c-treeRTG V2.0 and later). We are in the process of reintroducing this support into V12 (c-treeRTG V3.0). This keyword is still accepted by the parsing engine, and the Server engine will start, however the support is inactive so there are no benefits to adding this keyword at this time.

Dedicates a specified amount of cache memory to a particular Extended data file. This allows the Server Administrator to specify files that are critical to maintain in cache memory at the expense of the “least-recently-used” (LRU) approach, where a new cache page replaces the LRU existing page.

For example, the following keywords specify 100,000 bytes of dedicated cache for customer.dat and 400,000 bytes for data\inventory.dat:

SPECIAL_CACHE_FILE customer.dat#100000

SPECIAL_CACHE_FILE data\inventory.dat#400000

The <datafilename> can be a wildcard specification using a ‘?’ for a single character and a ‘*’ for zero or more characters. See FairCom DB Standard Wildcards.

Default: None

See Also

SPECIAL_CACHE_PERCENT

TOCIndex