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

[#1]

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.

[jagan]

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.

[Bill_Britt]

Hi,

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

Bill

[#4]

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?

[#5]

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. 

[rwunderlich]

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]

Hi Rob,

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

Many thanks,

Phil