topic Re: Even after Preload, Document is taking longer Time for first User. Why? in QlikView

Even after Preload, Document is taking longer Time for first User. Why?

Mon, 26 Jan 2026 18:19:17 GMT

Hi Guys,

I have enabled Preload option for Apps but still It is taking very long time when first time i open the document after publishing it?

Setting performed under Documents-->Source Documents-->App-->Distribution Task-->Server-->Performance-->Document Control-->Customize-->Cluster Node-->Document Available-->Always-->Preload

and

Documents-->User Documents-->App-->Server-->Performance-->Document Control-->Customize-->Cluster Node-->Document Available-->Always-->Preload

and also would like to know difference between these 2 Preload Options.

Re: Even after Preload, Document is taking longer Time for first User. Why?

jagan — Fri, 19 Jun 2015 07:46:13 GMT

Hi,

The performance of the load time depends on lot of factors. If you are displaying more data in tables then it will take more time to reload, for testing minimize the table object and try.

Regards,
jagan.

Re: Even after Preload, Document is taking longer Time for first User. Why?

Bill_Britt — Fri, 19 Jun 2015 11:21:14 GMT

Hi,

Set the opening sheet to a page that doesn't have some many charts to render.

Bill

Re: Even after Preload, Document is taking longer Time for first User. Why?

Tue, 23 Jun 2015 00:15:33 GMT

Hi Bill,

I want to open the Doc with first sheet only and this sheet having lot of charts and tables. I have another sheet which is called Custom and has nothing in it (This is for users to create their own dashboard).

If I make opening sheet as custom, how does it make difference? If users try to see first sheet, again it will take longer time.

There is any concept to do the Pre catching after reload of document?

Re: Even after Preload, Document is taking longer Time for first User. Why?

Tue, 23 Jun 2015 00:23:36 GMT

Also I did not see any properties to Set a Sheet as Opening sheet.

May I know how and where I need to perform this setting? Or just select a sheet which you want to make as Opening sheet and save the document and then Publish?

Please confirm.

Re: Even after Preload, Document is taking longer Time for first User. Why?

rwunderlich — Tue, 23 Jun 2015 01:23:40 GMT

The preload option only takes care of the read from disk into memory. It does not calculate any charts. If you want to precalculate ("warm the cache") the technique is to run a batch program that simulates user activity. There are number of approaches to doing this:

1. VBScript using the automation API

2. CURL or other program issuing http:// requests to the document.

3. Using Jmeter, generate the user interactions using Tool for easy creation of load/performance tests of QlikView (v.10 and 11)

Search the forum for "cache warming" and you're bound to get some ideas.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Even after Preload, Document is taking longer Time for first User. Why?

prees959 — Thu, 30 Aug 2018 10:11:16 GMT

Hi Rob,

Can you give an example of the VBScript and API Option?

Many thanks,

Phil