Skip to Main Content
Spotfire Ideas Portal

Allow for some tables to NOT be updated with Scheduled Updates via Web Player

I have an analysis that contains 2 fairly small tables that drive the main visualizations and I need these tables to be refreshed fairly quickly (every 2 min) so that the visualization always shows a current status. I also have multiple Data On Demand Tables that can be loaded depending on user selection - these DOD tables are fairly large (up to a million rows), but the data on these DOD tables is more stagnant and doesn't need to be auto refreshed. 

Currently when I set up an analysis for Auto Scheduled Updates, if a user has one of the large DOD tables loaded, it is reloaded with the Scheduled Update along with the non-DOD tables. This causes extra overhead in the Database (query that pulls up to 1 mil rows is re-run), Network (all that data is being passed across the network between the DB server and the Spotfire Server), and Spotfire (any calculated columns in the DOD tables is re-calculated and visualizations are re-build). 

It would be nice if a flag could be set on tables that would tell Spotfire to NOT reload the table upon scheduled updates of the Analysis file in the Web Player.

  • Attach files
      Drop here to upload
    • Guest
      Reply
      |
      Feb 22, 2017

      Use Server Info Link caching. Check the server manual.