Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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
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.
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.
Thanks everyone for your guidance and valuable advise.
I will do the nnedful as per above and see if it helps the clients.
Thank You..!!
If you have historical dashboards hide them in the windows file system and call them from another Qlikview