topic Reload Issue in QlikView

Reload Issue

Fri, 13 Aug 2010 07:18:27 GMT

Hey guys

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?

Any suggestions?

Thanks so much

Reload Issue

Anonymous — Fri, 13 Aug 2010 07:24:09 GMT

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.

Reload Issue

Fri, 13 Aug 2010 07:27:16 GMT

Johannes

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

Thanks again

Reload Issue

Fri, 13 Aug 2010 07:27:28 GMT

Hi,

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.

Regards,

Haneesh

Reload Issue

Fri, 13 Aug 2010 07:35:45 GMT

Hi,

Please find Rob's incremental reload example in the attachment. This is a good example for doing the incremental update reload.

The script comments explain the process clearly.

-Haneesh

Reload Issue

Fri, 13 Aug 2010 08:07:21 GMT

Haneesh

Thanks for the example. I don't quite understand it but im sure ill figure it out.