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.
Use Server Info Link caching. Check the server manual.