Is there a way to reduce the reload time of a qlikview document? have one that is approximately 16mb in size with data loaded from a MS Access database and it takes 53min to reload and it loads 61million records?
Well, if the MS Access load is taking a long time you might consider storing the data down to a QVD file and doing an incremental reload from the database.
Thanks for the quick reply. Can you maybe explain to me how to save the Access file as a QVD file? I don't quite understand the incremental reload either...
Sorry for the inconvenience. Is there maybe a qlikview for dummies somewhere? lol
You can reduce the reload time in any of the following ways,
- Avoid 'Select *' and load only the required fields. Tune the SQL query if it takes more time to execute
- If the DB performance is very poor, optimize the tables by techniques like indexing.
- If you have complex joins in the query and it it takes more time to execute, try to create a materialized view which would give the output of the query (This option is not feasible all the time, since it consumes additional DB space)
- Implement incremental load, if the history data doesn't change and you can also do update of few records which get updated
Some times reload time cannot be reduced drastically if it involve huge volume of data. But, you can always look for improvements in many ways as listed above.
