Skip to main content
15-Moonstone
September 26, 2023
Solved

Do too many cascading rules affect performance?

  • September 26, 2023
  • 1 reply
  • 1081 views

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

 

Best answer by Fadel

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.

1 reply

Fadel
Fadel23-Emerald IAnswer
23-Emerald I
September 27, 2023

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.

Buiꓘa
15-Moonstone
September 28, 2023

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