Question
Areteans
AU
Last activity: 2 Jul 2024 8:58 EDT
Performance Impact due to Expression builder in When rule
Hi This is very basic question , To understand the When Rule best practices ,
Note: I am using below mention When rule in CDH project where to check eligibility crietria which means this when rule can be executed against few million cutomers data hence trying to understand a best practice .
Example of when condition .
business Requriement :
Users are eligible if balance amount is greater than 0 but less than 2000000
and maturity date is in next 15 days.
Option 1 to create when rule :
A - balance amount > 0
B - balance amount < 2000000
C maturity date > current date
D maturity date < current date + 15
Logic : ( A AND B AND C AND D )
Option 2 for when rule :
A - (balance amount > 0 && balance amount < 2000000 )
B - ( maturity date > current date && maturity date < current date + 15 )
Logic : ( A AND B )
Please suggest which is the best option for performance . certainly Option 1 is good for Business user as its more readable but at the same time I am trying to understand is there any considerable performance improvement if I go with Option2.
Or please suggest any better option whcih can improve perfromance considerably .
Thanks in advacne.