Cache Management Best Practices

Good result cache management practices depend on a number of factors, such as the number of reports and documents in the project, the available disk space for caches, the amount of personalization in reports and documents, and whether you are using clustered Intelligence Servers.

MicroStrategy recommends the following best practices for cache management:

• The drive that holds the result caches should always have at least 10% of its capacity available.
• In a project with many reports, consider enabling caching on a report-by-report basis. Use MicroStrategy Enterprise Manager to determine which reports are used often and thus are good candidates for caching. For information about Enterprise Manager, see the Enterprise Manager Help. For information about enabling caching per report, see Configuring Result Cache Settings.
• Disable caching for reports and documents with a high amount of personalization, such as prompt answers or security filters.
• To reuse results for reports and documents with a high amount of personalization, use MicroStrategy OLAP Services to create Intelligent Cubes. For more information about OLAP Services, see the In-memory Analytics Help.
• If results are cached by user ID (see Configuring Result Cache Settings), it may be better to disable caching and instead use the History List. For information about the History List, see Saving Report Results: History List.
• Be aware of the various ways in which you can tune the caching properties to improve your system's performance. For a list of these properties, and an explanation of each, see Configuring Result Cache Settings.
• If you are using clustered Intelligence Servers, caching presents additional maintenance requirements. For information on maintaining caches in a clustered system, see Maintain Result Caches and History Lists in a Clustered Environment.