Reports Caching

Caching ("Administration / General caching settings") is the main tool of keeping Tracker in the operational condition in case of big data volumes. The more information is in the database, the longer it takes the database to perform queries and aggregate the data.

The caching process will prepare reports in a background mode, therefore it requires constant functioning of the cron script.

Caching prepares several types of reports:

1. Saved reports. You can indicate specific caching settings for each report. (Please remember that you can create your own time period.)
   
   
   
   
   
   
2. Ordinary statistics of campaigns and split tests. This statistics is displayed right in the lists of objects. Such statistics is prepared every hour by default.
3. Popular reports. Using the Reports Constructor you can open some reports more often than the others without saving them. In caching settings you can specify how often the report should be opened in order for it to be added to the cache.

"Smart caching" will try to determine how long it takes to prepare this or that report and will decide whether it is necessary to prepare the report in a background mode or it may be prepared and displayed in real time.

Report Preparing Methods

If you have Caching enabled then you might see a message that a certain report is not ready yet when you will try to open it. In this case you will also be presented with two options:

1. Add the report to the preparation queue (requires constant functioning of the cron script).
   This method is preferable as the work will be done in a background mode and the current server load will be taken into account. Also, this method doesn't depend on PHP script execution timeout settings and PHP won't terminate report preparation even if it will take a significant amount of time.
2. Prepare the report immediately.
   Choosing this variant, you will launch report preparation in real time as an http process. Your server's PHP timeout settings might prevent the report from finishing preparing, and the database load can become too big.

Time Zones

In the settings of a company (or companies) you can indicate the main time zone of the company (companies). This is necessary to prepare reports.

If you put a report in the preparation queue, the background process will be using the time zone of the company. The same time zone is used in preparation of the main system reports (for the list of campaigns, split tests and some of the Dashboard reports).

In all other cases (including the case when Caching is disabled) the time zone you’ve indicated in the Personal Settings is used.