Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
deepaktibhe
Valued Contributor

Performance optimisation

Hi,

Our QVW file size is vary huge.And giving slow response time.Is has having too many complex aggr functions on chart level as well.

I am sharing performance document analyzer file for our application  can you please suggest where should we go ahead to optimize the performances.

Thanks

12 Replies
Siva_Sankar
Honored Contributor

Re: Performance optimisation

Hi,

From summary tab, it shows you have 127MB of unused fields in the dashboard. You can remove those. Find the below.

~

Click the Objects tab, and sort the calc time. You will come to know which object is consuming more calc time. Eg

From the above information, go to the object id CH30, pivot table and check the expressions.

Siva_Sankar
Honored Contributor

Re: Performance optimisation

If you have many expressions, disable one by one and check which expression is consuming more calc time from the sheets tab, on the document properties.

Also refer https://community.qlik.com/blogs/qlikviewdesignblog/2013/01/28/memory-statistics

deepaktibhe
Valued Contributor

Re: Performance optimisation

Hi,

All those fields has been dropped already can you please tell me is there any difference between dropping fields and commenting out or removing the fields  the unused fields.

Thanks

Re: Performance optimisation

There are fair few Calculated Dimensions.

You could maybe look at sorting them in the script.

Pivot table CH30 would be the first dashboard object I would look at.

Siva_Sankar
Honored Contributor

Re: Performance optimisation

Deepak,

You can either comment or drop the unused fields. Make no difference.

deepaktibhe
Valued Contributor

Re: Performance optimisation

But after dropping fields also i do not know why fields  are showing as a unused fields in document analyzer and such kind of 127 fields are there.

Thanks

Re: Performance optimisation

Do check if these fields are used in any expression variables as Document Analyzer only finds fields that are directly used in Dimensions or Expressions, and not fields indirectly used via expressions.

deepaktibhe
Valued Contributor

Re: Performance optimisation

Hi All,

I got below info can u please see is this really bug,