Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Refresh data instead of reload?

Hi,

I have an application with quite some data in it (loaded from QVDs). So reloading of data takes some (too much) time. It seems like quite of a waste of time and processing power that the memory has to be cleared while historic data cannot be changed/deleted in my particular case. Having delta QVD's that update the QVW (without clearing the memory) will keep my data up-to-date while saving loading times.

I'm wondering if any of you have found a solution to this? Is there any difference in how QV desktop and server client handle reloading? 

Any other solutions will be appreciated, help or pointers will be appreciated!

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

I reckon one answer to that would be that it's highly unlikely that anything from the last hour is really relevant in the context of five years of data. Maybe you should not try to do everything in one document.

However if you must have five years of hourly data including the last hour in one document then you're stuck with either reloading everything every hour or some messing about with Dynamic Update actions. See here and here for some information.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See here and then here.


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert,

so if I'm correct the only way is to refresh the complete memory and the refresh speed can be improved by better separating my QVD from QVW files?

Yet it still seems unnecessary to me to reload 5 years of data if only 1 hour of data has changed?

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

I reckon one answer to that would be that it's highly unlikely that anything from the last hour is really relevant in the context of five years of data. Maybe you should not try to do everything in one document.

However if you must have five years of hourly data including the last hour in one document then you're stuck with either reloading everything every hour or some messing about with Dynamic Update actions. See here and here for some information.


talk is cheap, supply exceeds demand