Changes

Jump to: navigation, search

Enable Caching

1,293 bytes removed, 17:57, 2 July 2019
The '''Enable Caching''' options on the #REDIRECT [[:Category:Reports|#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 Field Caching''' option.:[[Image:Repcache.png]] * 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. ==See Also==* [[Straight Join]]  [[Category:Reports]]
2,299
edits

Navigation menu