topic Re: slow loading document in access point in QlikView

slow loading document in access point

felcar2013 — Mon, 26 Jan 2026 18:19:17 GMT

is the size of the qlikview document a problem when loading in the access point? I have a 6 Gb document and when opening it, it lasts several minutes

is there a way to speed up the loading? or is this more a problem to be solved in the script? (optimize it and reduce data)

Re: slow loading document in access point

erichshiino — Tue, 19 Feb 2013 18:17:40 GMT

Hi,

If you can make your document smaller, it will be faster to open.

Maybe there are some unused fields you can remove.

You can use Rob's document analyzer (http://robwunderlich.com/downloads/ ) to identify those fields.

It may be useful to check if you need all your data in the application ( for example, you can remove old data)

You can reduce this loading problem by making the document always available in the memory ( if this is an option for you). You can set this in QMC -> User document tab -> select your document -> on the right, go to the server tab-> availability tab-> check the preload option.

It will take some time to reload the application to the memory after every data reload.

Qv applications are stored in a compressed format by default. It is a trade-off. When you compress it, it will become a smaller file, but it may take longer to open it. You can disable it ( and compare the results) in document settings->general tab -> save format: compression. It may even take longer depending on the performance of your disks...

Hope it helps,

Erich

Re: slow loading document in access point

felcar2013 — Wed, 20 Feb 2013 12:53:18 GMT

Hi Erich

thanks for this. As said, i reduced the size of document and went better. The link you sent is excellent.

the option you said about making the document available in memory is located in the "performance tab" of the Server tab. There is a "preload" option. Is that what you mean? in the availability tab i do not see a "preload" option.

thanks again

felipe

Re: slow loading document in access point

erichshiino — Wed, 20 Feb 2013 13:22:14 GMT

Yes, my mistake!

It's the preload option in the performance tab.

Regards,

Erich