Skip to Main Content
Spotfire Ideas Portal
Status To be Reviewed
Categories caching
Created by Guest
Created on Mar 13, 2023

Add No cache refresh option to select

If you run a select on a cached table, and the cache is empty, the cache will automatically start to refresh.

Sometimes you don't want that, as you only want the cache to refresh in tandem with other tables, or only at given times, while there may be a valid reason why at that moment the cached table is empty.

And it's not a given that an empty cache indicates that this is something that is quick to reload. For instance is the query only shows discrepancies between two datasources, and thus needs to do a costly comparison, which is the reason it is cached and scheduled in the first place.


Currently there are options to ignore a cache and select from the source, but there is no option to do a select on a cached table but not trigger the cache refresh. Please add one.

  • Attach files