Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aj0031724
Partner - Creator
Partner - Creator

Qlikview document access point loading performance improvement

Dear Team,

We have splitted qvw models each qvw size on average is 2-3 GB .Schedukre run each night and reload the data for qvw.

during dAYTIME ,When clinets  opened the document from access point it tooks almost 10-15 minutes for documenst to get populated with data for all charts/objects which is not accepatabel to the uers.

Theyare asking us to optimize performace during dashabord opening.

Can you please suggest what are the variuous ways of improving perfomce during document opening .

6 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

In QMC, enable the 'Preload' option for all documents that need better loading performance.

See QMC->Documents->User Documents->Select a doc->Server->Performance->Document Control->Preload

Peter

flipside
Partner - Specialist II
Partner - Specialist II

When the document is opened for the first time it loads the document into RAM on the server and should be quicker for all subsequent users who open it (subject to document timeout settings). You can improve the first opening by pre-loading the document in QMC (Document > Server > Performance). So if you reload at 6am, set the preload and have a timeout of 480 minutes (8hrs), it will reside in memory until 2pm if nobody opens it. (There are a number of places to set the document timeout (System > Setup > Server > Documents and in the performance area above).

If it's a problem for every time someone uses it then you either need to optimize the document or improve the server spec.. Try searching for server optimization documents on here.

PradeepReddy
Specialist II
Specialist II

some tips to improve the document performance..

1. Don't load the historical data.  I mean load the data for last 5-7 years as per the user requirement.

2. Do all possible calculations in script it self.

3. Minimize the objects which are not necessary at first look.

4. On opening the document, restrict the data to latest 3 years.

5. Drop the unnecessary fields from the data model.

Analyze the document performance, by using Document analyzer, it will give you which object taking more time.

aj0031724
Partner - Creator
Partner - Creator
Author

Thanks everyone for your guidance and valuable advise.

I will do the nnedful as per above and see if it helps the clients.

lakshmanvepuri
Creator
Creator

Thank You..!!

Anonymous
Not applicable

If you have historical dashboards hide them in the windows file system and call them from another Qlikview