Not / or should be avoided leads to longer runtime.

1
Hi, I followed my ACR-recommendations and implemented this rule. https://sdf-docs.mansystems.com/docs/acr-rules/Performance/NotOrXpath/ As a result, my Microflow ran for 8032ms instead of 6694ms (APD recored this times). Is there a rule of thumb, when I should follow this rule and when not?    Before:     After       Thank you!
asked
1 answers
2

Hi Tjark,

I would be suprised if anyone could provide a one-size-fits-all rule of thumb for this. It depends on soo many factors: the size of the datasets, the diversity of the datasets, the amount of joins, the amount of available server memory etc.

It is possbile to reason on this a little bit, see also:

https://docs.mendix.com/refguide/performance-best-practices#mxp007

https://academy.mendix.com/link/module/22/lecture/180/4.5-XPath-Optimizations 

But in the end testing out different variations is the proof of the pudding to me.

I hope this helps.

answered