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.

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). However, cache schedules can only be edited in the report designer, as described in this section.

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-07-06 18:02:44 UTC

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