Specifying Cache resource limits

With this resource limit enabled, when a query is run, the results will be cached. If the query is run again, and nothing has changed, the results will be taken from the cached results rather than run again at the data source. Cache resource limits can be applied to both data sources and individual queries.

The Cache resource limits are as follows:

Cache is enabled

This field specifies whether the caching of result set data is enabled. Caching is disabled by default. If caching is enabled, result data from a query is cached (stored) and is available for use by other users that have the same privileges to access this data on the data source. Caching result set data can significantly decrease resource consumption and improve performance. The cached result set data is not automatically refreshed.

Auto data fetching enabled

This field specifies how the cached rows of data will be retrieved. This resource limit becomes available if Cache is enabled is selected. When selected, this option specifies that if the query result set is taken from the cache, the entire result set will be presented. When this option is not selected, 100 rows (the default) of the query result set is presented.

Data expiration interval

This field specifies the time period the query result set data will remain in cache. You can set the time period by specifying the number of days, hours, and minutes. After this period, the cached query result set data will be updated.

Cache options can be overridden

This field specifies whether the cache options can be overridden.