topic Re: How to increase performance. in QlikView

How to increase performance.

Thu, 05 Dec 2013 06:00:38 GMT

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

Re: How to increase performance.

kaushiknsolanki — Thu, 05 Dec 2013 06:38:05 GMT

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

Re: How to increase performance.

sujeetsingh — Thu, 05 Dec 2013 06:46:23 GMT

1)-Follow best data model concept

2)-try reducing unused fields

follow this link

http://community.qlik.com/docs/DOC-4556

Re: How to increase performance.

Thu, 05 Dec 2013 06:49:05 GMT

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

Re: How to increase performance.

ngulliver — Fri, 06 Dec 2013 08:32:24 GMT

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

Re: How to increase performance.

Fri, 06 Dec 2013 10:22:36 GMT

Hi Neil,

Thanks for your valuable suggestion.

Regards,

Piyush