Hello,
Just want a a clarity on one concept - when we setup cache setting under "Data connection " tab with balanced options. how exactly it works.
Per online help -
*************************
Balanced—Data is removed from the cache after a specified number of minutes. If the data has been added to the cache within the specified time range the cached data will be used, otherwise new data will be queried from the database
************************
My Question - lets say I set 60 mins for Balanced option then -
A. will It clear all cache data after 60 minutes for each workbook /view exist in tableau server even though few workbooks data just added to cache ? OR
B. It will just clear cache data for workbooks /view those were rendered 60 minutes ago and will keep cache data for those workbooks/view those just rendered ( less then 60 minutes ago)
C. There is no mapping between cache data and views/dashboard , cache data can be consumed by multiple workbooks if result exist within cache data( cache hit) else it will be a cache miss and new data will be added to cache after querying database,but in that case what would be start time of 60 min counter assuming my tableau server rarely start/restarts ?
Thanks in advance.
Sunil Tikar
My comments below:
Sunil Tikar wrote:
...
My Question - lets say I set 60 mins for Balanced option then -
A. will It clear all cache data after 60 minutes for each workbook /view exist in tableau server even though few workbooks data just added to cache ? NO
B. It will just clear cache data for workbooks /view those were rendered 60 minutes ago and will keep cache data for those workbooks/view those just rendered ( less then 60 minutes ago) YES
C. There is no mapping between cache data and views/dashboard , cache data can be consumed by multiple workbooks if result exist within cache data( cache hit) else it will be a cache miss and new data will be added to cache after querying database,but in that case what would be start time of 60 min counter assuming my tableau server rarely start/restarts ? Ya lost me