|
|
| (3 intermediate revisions by one other user not shown) |
| Line 1: |
Line 1: |
| − | The '''Enable Caching''' options on the [[Edit Report Page: Advanced Settings Tab|Advanced settings tab]] of the [[:Category:Reports|Report]] editing page can be used to:
| + | #REDIRECT [[Reports#Report and Field Caching]] |
| − | * 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.
| |
| − | :[[Image:Repcache.png]]
| |
| − | | |
| − | * Reports can also be '''Cached By User''', when appropriate, such as when the report includes [[:Category:Criteria|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]]
| |
| − | | |
| − | | |
| − | [[Category:Reports]]
| |
