Performance Impact

[Anonymous]

Hi All,

Can anyone of you please tell me which one is better to use in Set Analysis Expressions -

Only()

Maxstring()

Concat()

Which one will have least impact on Performance.

Please assist on same.

Regards,

MK

[cesaraccardi]

Hi,

Can you provide an example of whatyou would like to achieve?

[manojkulkarni]

use of above function dependent on your requirement and on what type field being used.

[Anonymous]

Suppose I have a requirement where I want to write condition like -

Maxstring({<field=P({<$(var1)>}field2),$(var2), field3=>}field4)

In this case, which expression will be having least impact on Performance, whether i should use -

Only()

Maxstring()

Concat()

Regards,

MK

[cesaraccardi]

Ok thanks, I think I understand now.

If the goal is to reduce a list of text values to a single value then I would suggest to use Only() as it is a basic aggregation function and doesn't have any additional processing to find out what is the maximum value, like maxstring() for example.

Now regarding Concat() the result would not be the same as Only() unless if you include a DISTINCT parameter inside the function which I suspect (not 100% sure) will be less performant than Only().

Hope this helps,

Cesar

[cesaraccardi]

By the way, I am assuming all the values on the field you are aggregating are the same. Please let me know if this is not the case.

[rajeshvaswani77]

Overall the Set Expression will give you a performance benefit.

thanks,

Rajesh Vaswani