Which aggregate function is good at performance

hyudolee
Occasional Contributor

Which aggregate function is good at performance

Hi, I want to use aggregate function.

I want to aggregate "Date" Lineitem from Order A&B to Aggregation Module.

Date Lineitem has Date format.

 

I use " OrderA.Date[Max:Product]" as Formula.

And I can also use "Fristnonblank" and so on because Date Lineitem is common in module.

 

Which Formula is good at performance?

 

hyudolee_3-1639731804513.png

hyudolee_4-1639731816594.png

 

hyudolee_2-1639731382660.png

 

Each Order has Product, But Product will not duplicate.

And Order A and Order B has own date. It depends on Own module.

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

Re: Which aggregate function is good at performance

@hyudolee 

 

I don't think there is any work that has been done on the comparison of the performance of these aggregation functions. I have a feeling that these two will perform almost similarly.

 

Misbah

Miz Logix

View solution in original post

1 REPLY 1
Misbah
Moderator

Re: Which aggregate function is good at performance

@hyudolee 

 

I don't think there is any work that has been done on the comparison of the performance of these aggregation functions. I have a feeling that these two will perform almost similarly.

 

Misbah

Miz Logix