Spotfire web player performance - Delay in loading file : shows: Reading data, xxxxx rows read
I am working on an analysis file with over 20 million(+) records viewed through web player with the scheduled updates set to run on every 12 hours. While opening the file through web player, it is showing Reading data- xxxx rows read and it is taking approx. 4 hours to load the file in web player!!! User expects the file to be loaded in less than 30 seconds time. The user also needs to have historical data and so, we cannot remove or minimize the dataset.
What are the techniques with which I can improve the performance of the web player? How to load the cached data in a shorter time span?
Thanks in advance.