topic 5 minutes for one Click, reusable expression variable performance in QlikView

5 minutes for one Click, reusable expression variable performance

Thu, 31 Mar 2011 12:00:19 GMT

Hi,

my qvw with only version 8 features is about 450MB in memory when not navigating or when all figures are calculated. But sometimes when I click the application I wait up to 5 minutes to be ready for the next navigation. During that the memory consumption is going up several times to 3, 6, 9 even 13! GB.

I am using expressions in variables. What is happening there?

Many posts here mention performance issues. But I never had expected as so bad.

Is there a workaround? Any Idea how I define reusable expressions centrally without running into performance issues?

rgds Eckhard

5 minutes for one Click, reusable expression variable performance

IAMDV — Thu, 31 Mar 2011 12:09:19 GMT

Eckhard - I had similar problem while using variables in expressions. The charts which uses expressions & variables is flickering on every click. I could not find a specific solution but I had loaded pre-calculated data for the non-dynamic values in the loading script to reduce the overhead on the QV calculation engine. I had also commented/removed columns which are not necessary for this document.

I'll be watching this post very closely for expert suggestions.

Cheers - DV

5 minutes for one Click, reusable expression variable performance

IAMDV — Thu, 31 Mar 2011 13:35:25 GMT

QV Experts please help on this one...

TIA

Cheers!

5 minutes for one Click, reusable expression variable performance

Thu, 31 Mar 2011 15:36:49 GMT

I have the reason. I have some huge posting tables and in the middle the PostingOwner. My expressions contain variables from input boxes. I compared these variables with fields of PostingOwner but added values of posting table. This takes the time!

It is better when I compare the variables with fields of the posting table.

rgds Eckhard