Skip to Main Content
Spotfire Ideas Portal
Status Already exists
Categories performance
Created by Guest
Created on Apr 18, 2023

Do cache refresh in push down where possible

In case the cache table is in the same database as all the other tables contributing to the cache, the cache refresh should run in full push down. This instead of selecting and bringing all the data from the database to the TDV server and then sending it back from the TDV server to the database.

  • Attach files
  • Guest
    May 4, 2023

    We are looking to evaluate this idea further and it would help to know if this is been created with any specific data source adapter in mind. If yes, it would also be helpful to know the version of the adapter for us to review if this functionality can be supported.

  • Guest
    Apr 19, 2023

    Gooe idea, but shouldn't that be configurable? Not all sources can handle the reporting cache beside their own process required cache.