Any tips for troubleshooting business rule performance on form loads?

Digit
Kilo Guru

We have a form that is loading super slowly, and I am trying to determine which related list is causing the issue.
I'm planning on removing each on a one-by-one basis, but would love to know if there are any more tips for debugging these (something along the lines of Slow Query, Slow Transactions, etc)? I was also trying to gauge business rule affects this as well, but see nothing; hopefully I'm just missing something.

Also, once I know it's a related list causing the issue and which one, do you know of any ways to improve the load times, other than indexing the tables?

 

Thanks for the information!!

 

7 REPLIES 7

Aman Kumar S
Kilo Patron

Hey,

How can you be so sure that it has to be the related lists?

Can't it be the onLoad scripts(including UI policies) or Display BRs?

Follow below link to do performace review of BRs:

Verifying whether you have inefficient business rules

 

 

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂

Best Regards
Aman Kumar

Allen Andreas
Administrator
Administrator

Hello,

Do you have a significant number of related lists or the related list have tons of records? You'd want to ensure only appropriate related list are showing and consider removing some. You can also assist with filtering the related list to only show truly relevant records, as best as possible.

Without more information from you, perhaps a screenshot of the fully loaded form and related list with record count, we can only give general information.

It may not even be related lists...and could be faulty filtering or something on a field on the form.

Please mark reply as Helpful/Correct, if applicable. Thanks!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

Hello,

Business rules wouldn't affect the page loading (unless it's something crazy with a specific display business rule...but I wouldn't even suspect that first and foremost).

If the related lists only have 30 records, then it may not be those either.

As I mentioned above, it could be a bad reference qualifier or something on a field on the form. I'd recommend checking all of your reference fields for perhaps a reference qualifier and consider removing it, loading the page and see if the issue remains or not, adding it, back and rinse and repeat.

Please mark reply as Helpful/Correct, if applicable. Thanks!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

Digit
Kilo Guru

Allen / Aman,
I'm assuming that it's related list loading that's causing the issue, as I switched my form settings to 'After Form Loads', and the form appeared immediately, but at the bottom I saw that related lists were still loading. It took about 20-30 seconds. Are you aware of anything else that could cause that behavior?

I only have 4 related lists on the form, and none of them produce row counts of more than 30 rows, so it's surprising to me that it's even an issue. That was what made me want to check business rules as well.

Aman, thanks for the link. I'll see if there's anything helpful there.