topic Re: What is a performance efficient way to write SUM expression with nested AGGR inside? in App Development

What is a performance efficient way to write SUM expression with nested AGGR inside?

jblomqvist — Tue, 17 Jul 2018 11:15:15 GMT

Hi,

Let's say I have an expression like this:

SUM(

Pick($(vSelectorValue),

Aggr(Sales),

Aggr(Orders),

Aggr(Shipments)

)

The idea is to SUM one of the Aggr values based on the variable value of vSelectorValue.

Is the above expression an efficient way to write? Is there a better way to write the expression to make it efficient?

Of course I am aware that Aggr can be performance impacting but my question is around the above expression.

sunny_talwar — Tue, 17 Jul 2018 11:17:47 GMT

Why do you need Aggr() here? Is Sales, Order, and Shipments expressions or fields? If they are fields, why don't you just do this

Sum(Pick($(vSelectorValue), Sales, Orders, Shipments))

jblomqvist — Tue, 17 Jul 2018 11:48:51 GMT

Hi Sunny,

It's because I am presenting a simplified version for the question.

In reality my Aggr is a bit more complex and contains variables etc inside.

sunny_talwar — Tue, 17 Jul 2018 11:50:16 GMT

Without seeing the real thing, it might be difficult to suggest ideas for improvement...