MicroStrategy ONE

Location of Result Caches

Separate result caches are created for each project on an Intelligence Server. They are kept in memory and on disk. The server manages the swapping of these caches between memory and disk automatically. Caches are automatically unloaded, beginning with the least recently used cache, until the maximum memory governing limits are reached.

The amount of memory available to store result caches is limited by the Memory Storage settings. For information, see Configuring Result Cache Settings.

Result Cache Files

By default, result cache files are stored in the directory where Intelligence Server is installed \Caches\ServerDefinition\Machine Name\. Report caches are stored in this folder; document caches are stored in the \RWDCache\ subfolder of this folder.

Report Cache File Format

Report caches are stored on the disk in a binary file format. Each report cache has two parts:

  • Cache<cache ID>_Info.che contains information about the cache, such as the user and prompt answers.
  • Cache<cache ID>.che contains the actual data for the cache.

Report Cache Index Files

Intelligence Server creates two types of index files to identify and locate report caches:

  • CachePool.idx is an index file that contains a list of all Matching and History caches and pointers to the caches' locations.
  • CacheLkUp.idx is a lookup table that contains the list of all Matching caches and their corresponding cache keys. Incoming report requests are matched to report cache keys in this table to determine whether a Matching cache can be used. This process is called cache matching (see Cache Matching Algorithm). This lookup table is always backed up to disk when Intelligence Server shuts down. Additional backups are based on the Backup frequency and the Lookup Cleanup Frequency settings (see Configuring Result Cache Settings).

Document Cache File Format

Document caches are stored on the disk in a binary file format. Each document cache has two parts:

  • <cache ID>_info.rwdc contains information about the cache, such as the user and prompt answers.
  • <cache ID>.rwdc contains the actual data for the cache.

Document Cache Index Files

Intelligence Server creates two types of index files to identify and locate document caches:

  • RWDPool.idx is an index file that contains a list of all Matching caches and pointers to the caches' locations.
  • RWDLkUp.idx is a lookup table that contains the list of all Matching caches and their corresponding cache keys. Incoming document requests from Web are matched to document cache keys in this table to determine whether a Matching cache can be used. This process is called cache matching (see Cache Matching Algorithm). The lookup table is always backed up to disk when Intelligence Server shuts down. Additional backups are based on the Backup frequency and the Lookup Cleanup Frequency settings (see Configuring Result Cache Settings).