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.
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.
Gooe idea, but shouldn't that be configurable? Not all sources can handle the reporting cache beside their own process required cache.