Difference between revisions of "Enable Caching"

Revision as of 09:39, 30 April 2013

The Enable Caching options on the Advanced settings tab of the Report editing page can be used to:

• help improve loading time; and
• reduce the processing load on the server.

Complex reports and reports that are accessed regularly will benefit the most from the Enable Caching option.

• Reports can also be Cached By User, when appropriate, such as when the report includes criteria to filter based on the user that opens the report (i.e. =@userid@).

Note: you must select both Enable Caching and Cache by User to cache by user.

• Enter an appropriate Cache Life Span in minutes.

Rather than re-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 be created by querying the database and live data will be displayed.
• Anyone viewing the report after this, within the life span specified, will see a snapshot of the report from the cache. Changes 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

• Caching must NOT be enabled for reports that prompt the user for criteria.
• Cached reports that include criteria based on the current user (i.e. @userid@) must be Cached By User.
• In general, sub-reports should not be cached. The parent report can be cached if appropriate.

See Also

• Straight Join