Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can we improveperformance of a existing dashboard. what parameters should be taken into account and what kind of tools should be used to do so. please advice.
Regards,
Piyush
Hi,
There are many aspects which needs to be considered while optimizing the application.
1. Dashboard (Application) Side:
You must check whether the application is created with the given best practices or not.
Also you should see whether there are any If statements in the Expression or not.
2. You also need to check the server configurations, like RAM, Processors, Preload Options.
You can use the Memory Utilization file (.mem) which stores chart level avg calculation time, this will help you to understand which chart takes more time.
Regards,
Kaushik Solanki
1)-Follow best data model concept
2)-try reducing unused fields
follow this link
Hi Piyush,
Not sure about your data source but you may look at below points in general for optimizing:
1) Good data model - Remove Synthetic keys and Loops( These reduce the performance)
2) Use QVD's for faster loading if the data source are flat files.
3) Implement partial reload if there is a scope to add.
4) Try to have both the application server, database server and qlikview server in same environments.
5) Use Advanced SQL (SSAS) which will improve your performance.
As mentioned by Kaushik, if you have a RAM of size 256mb it can load data upto 2TB fastly. So based on your data, increase the size of your RAM.
Hope this helps!
Thanks,
Sai Krishna
Following Sai's comments.
Have a look at the blogs on Steve Dark's Quick Intelligence website ( I won't put an external link as this gets held up by Moderators). There is a recent one covering best uses of QVD generation and for optimizing your load.
Regards,
Neil
Hi Neil,
Thanks for your valuable suggestion.
Regards,
Piyush