Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Not applicable

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

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.

6 Replies
MVP
MVP

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

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.

Employee
Employee

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

Hi,

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

Bill

Not applicable

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

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?

Not applicable

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

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?

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

prees959
Contributor

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

Hi Rob,

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

Many thanks,

Phil

Community Browser