Is performance issue raises using Set Analysis ?

[#1]

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

[alexandros17]

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

[er_mohit]

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

[#4]

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.