Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

felcar2013
Contributor II

slow loading document in access point

hi

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)

3 Replies
erich_shiino
Honored Contributor

Re: slow loading document in access point

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

felcar2013
Contributor II

Re: slow loading document in access point

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

erich_shiino
Honored Contributor

Re: slow loading document in access point

Yes, my mistake!

It's the preload option in the performance tab.

Regards,

Erich