5 minutes for one Click, reusable expression variable performance
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?
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.
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.
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.
