Enable Caching
The Enable Caching options on the Report settings page can be used to help improve loading time and reduce the processing load on the server.
Complex report and reports that are accessed regularly will benefit the most from the Enable Caching option.
- Reports can also be Cached By User when appropriate (Note that you must select both Enable Caching and Cache by User and enter an appropriate Cache Life Span
Rather than creating the report each time it is run, caching stores the results for the duration specified in the Cache Life Span field.:
- The first time a report is viewed it will create it by querying the database and show live data.
- Anyone viewing the report after this, within the life span specified will see a snapshot of the report from the cache. Changed to underlying data will not be reflected in the report during the Cache Life Span
- The report will be updated once the life span has expired, and any changes to the underlying data will then be reflected.
IMPORTANT
- Reports that prompt for criteria should NOT be cached in any way.
- Reports that include criteria based on the current user (i.e. @userid@) must be cached by user.