Difference between revisions of "Enable Caching"

From SmartWiki
Jump to: navigation, search
(Redirected page to Reports#Report and Field Caching)
 
Line 1: Line 1:
The '''Enable Caching''' options on the [[Edit Report Page: Advanced Settings Tab|Advanced settings tab]] of the [[Edit Report 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 and 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]]
 
* [[Scheduled Reports]]
 
 
 
 
 
[[Category:Reports]]
 

Latest revision as of 13:57, 2 July 2019