topic Re: Is performance issue raises using Set Analysis ? in QlikView

Is performance issue raises using Set Analysis ?

Tue, 28 May 2013 13:01:22 GMT

Hi,

Will Set Analysis operation in the expression will reduce the performance when loading very big amount of data and if having more sheets and objects.

Please let me know.

Thanks in advnace

Re: Is performance issue raises using Set Analysis ?

alexandros17 — Tue, 28 May 2013 13:06:20 GMT

At the opposite set analysis improve pervormances against If conditions;

Obviously with big amounts of data you have to optimize all the expressions and even data.

hope it helps

Re: Is performance issue raises using Set Analysis ?

er_mohit — Tue, 28 May 2013 13:29:39 GMT

With using Set Analysis If you have Quite a very big data then It Increase the performance Reduce the time response .

Set analysis can be CPU intense and thus Set Analysis should be tested in work situations to make sure that it does not slow the application down.

http://qvdesign.wordpress.com/2012/01/30/set-analysis-good-for-you-bad-for-your-ram/

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=_CNGH

hope it helps you

Regards

Mohit

Re: Is performance issue raises using Set Analysis ?

Tue, 28 May 2013 13:36:26 GMT

I think,

if you write the code in expression then performance decreases in compareson to write in script.

now In expression if you get the same out from either set analysis or if condition,

with the help of setanalysis we reduce the number of line code which are written in if condition.

so must be used set analysis. Set analysis increases the performance than if condition.