Strategy Intelligence Server creates two types of index files to identify and locate report caches. The location of these index files is the same as the location of report cache files:
Windows:
C:\Program Files\MicroStrategy\IntelligenceServer\Caches\<Server Definition>\<Machine Name>
Linux/Unix:
/<Strategy HOME>/Intelligence Server/Caches/<Server Definition>\<Machine Name>
- CachePool.idx: is an index file that contains the 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 if a Matching cache can be used. This process is called cache matching. CacheLkUp.idx file can become significant in size especially when there are a large number of reports that include a large number of prompts. The cleanup process reduces the amount of memory the file consumes and the time it takes to back up the lookup table to disk.
There are two main settings that are important in the CacheLkUp cleanup process:
- Cache lookup cleanup frequency (sec) setting determines how frequently the CacheLKUP.idx file is cleaned up. The default value for this setting is 0, which means that the cleanup takes place only at server shutdown. Users can change this value to another based on their needs, but need to ensure that it does not negatively affect system performance. Strategy recommends cleaning the cache lookup at least daily but not more frequently than every half hour.
- Backup Frequency (minutes) When a report cache is created, the cache is initially stored in memory on Strategy Intelligence Server. Caches are backed up to disk as specified by the Server backup frequency setting.The default value for this setting is 0, which means that the report caches are saved to disk as soon as they are created. A backup frequency of 10 (minutes), means that the report caches are backed up from memory to disk ten minutes after they are created.
The above two settings can be specified under the Server definition -> Advanced subcategory in the Strategy Intelligence Server Configuration editor as seen below:
