Scroll

Execution Caching

Caution: You are strongly encouraged to contact the Support Department before enabling Execution Caching.

Execution caching allows you to save the data from a report execution, so that reports can be viewed more quickly, and with less stress to the database. The frequency and schedule of database updates is customizable for each report. Updates can be scheduled for off-hours in order to better balance system load. Caching can significantly reduce database calls for reports which are accessed frequently. Large or data-intensive reports, which can take a long time to run, especially benefit from caching.

Enabling Execution Caching

Execution caching uses the report scheduling services and the scheduling user interface to cache the data and set the refresh intervals. When caching is enabled for a report, a caching schedule is created for that report which determines how often the data is refreshed. Scheduling services need to be enabled for the user or users who will be setting the caches; however, users who only need to view the cached reports do not need to have scheduling enabled.

To enable execution caching, set the following admin console setting to true:

( Scheduler Settings ) Enable Execution Cache

Note: The following administrative settings that affect access to some schedule recurrence options will also affect the recurrence options available in the execution caching window:

( Scheduler Settings ) Show Schedule No End Date Option
( Scheduler Settings ) Show Schedule Intraday Recurrence Option

The cache data is stored in the scheduler temporary directory, so you should make sure that the max_temp_file_age scheduler setting is high enough that caches will not be purged unpredictably. See Scheduler Configuration for details.

Setting Cached Reports and Refresh Intervals

To set up caching for an advanced report:

  1. From the ReportOptions.png Report Options menu, click Options.png Options > ExecutionCacheOptions.png Execution Caching.

  2. Select the Enable execution caching check box.

  3. Choose how often the cache is updated:

    1. Enter a time of day in the Schedule Time field, or use the picker to select a time.

    2. Optional: To update the cache multiple times per day, select the Repeat Every check box and enter a time for how often it should repeat.

      Optional: To repeat until a certain time of day, enter that time in the until field, or use the picker to select a time.

  4. Choose which days of the week the cache is updated. Select either:

    • To repeat every day or every number of days, click Every __ day(s) and enter a number of days for how often it should repeat.

    • To repeat every Mon, Tues, Wed, Thurs, and Fri, click Every weekday.

  5. Click OK.

When execution caching is enabled for a report, the cache is not created immediately. To run the report, you can manually create the cache by clicking the refresh CacheInvalid.png icon, or you can wait until the first scheduled update completes. The cache can always be updated manually by clicking this icon.

Cache schedules are visible in the schedule manager, with the label (cache). Caches can be edited or deleted using the schedule manager or the advanced report designer.

Editing cached reports

Editing a cached report invalidates its cache. It cannot be run until the cache is updated. A missing or invalid cache is indicated by the message Cache is invalid, both in the report description and in the right-click menu for the report.

It is recommended that you fully design a report first, so that you can manually verify the output, before enabling the cache.


Hidden Article Information

Article Author
Exago Development
created 2017-05-15 17:29:04 UTC
updated 2017-10-09 16:45:02 UTC

Labels
Recurrence, cache, background, save data,
Have more questions? Submit a request