skip to main content
SQL Statements and Extensions for the Salesforce Driver : Create Cache (EXT) : Refresh Interval Clause
  
Refresh Interval Clause
Purpose
The Refresh Interval clause specifies the length of time the data in the cached table can be used before being refreshed; it is optional. The driver maintains a timestamp of when the data in a table was last refreshed. When a cached table is used in a query, the driver checks if the current time is greater than the last refresh time plus the value of Refresh_Interval. If it is, the driver refreshes the data in the cached table before processing the query.
Syntax
[REFRESH_INTERVAL {0 | -1 | interval_value [{M, H, D}]}]
where:
0
specifies that the cache is refreshed manually. You can use the Refresh Cache statement to refresh the cache manually.
-1
resets the refresh interval to the default value of 12 hours.
interval_value
is a positive integer that specifies the amount of time between refreshes. The default unit of time is hours (H). You can also specify M for minutes or D for days. For example, 60M would set the time between refreshes to 60 minutes.The default refresh interval is 12 hours.