As the Scheduler will run a query for each set of parameters held in Views for a Dataset we may wish to exclude some views from being cached in order to reduce impact on the source system.
To exclude a view from being cached, click on the views icon for the Dataset in question ( ) to display a pop-up screen of all views against that Dataset and tick the checkbox in the “Exclude from Cache” column for that view:
Typical cases where this functionality might be used include:
- Rarely used views that query a much larger set of data than usual (e.g. multiple years of transnational data rather than a number of days or weeks)
- Views of Datasets that have User or IP Parameters defined for a large number of users / locations where only a small number of those users actually use the Dataset.