MicroStrategy Quick Start Guide

Improving Reporting Performance – MicroStrategy Cache

When a Report is executed, it goes through the cycle we described in Chapter 1, Architecture - Installing and Configuring MicroStrategy, (Refer to Intelligent Server Engines): SQL Generation-Query Execution-Results format and Crosstab. However, for both complex Reports and very large Result sets, this process could take time and resources each time the Report is executed. For scenarios where ad hoc reporting is not needed, the result set from a previously executed Report can be stored in what MicroStrategy calls a cache. When a user executes a Report, a cache is created within a file and the Intelligence Server loads the result set into its memory.  Report caching can be enabled either ...