Skip to main content
Sep 26, 2023 4:27 PM UTC
Solved

Do too many cascading rules affect performance?

Dears,

 

I have customized two attributes in the part subtype which have a cascading relationship, attribute A has roughly 70 values, attribute B has roughly 1000 values, attribute A is level1, attribute B is level2, attribute A is one-to-many for attribute B. I am considering if there is a performance issue if I create 70 rules in cascading? If there is a performance issue, is there any other suitable way to handle such attributes? Thanks

 

BR,

Chason

 

FadelAnswer
3-Newcomer
Sep 27, 2023 9:38 AM UTC

you may have performance issues in the create new wizard loading time  ,but generally starting 3000 cascading rules

Issue is due to client need to handle a huge response from server, there is no database or code improvement.
You will have to review with business to decrease number of rules.

2 replies

FadelAnswer
3-Newcomer
Sep 27, 2023 9:38 AM UTC

you may have performance issues in the create new wizard loading time  ,but generally starting 3000 cascading rules

Issue is due to client need to handle a huge response from server, there is no database or code improvement.
You will have to review with business to decrease number of rules.

Sep 28, 2023 5:38 AM UTC

@Fadel  Thank you very much for your information, it is very useful.