Does Related Lists in Agent workspace affects the performance.

[Ramkumar Thanga]

Hello Everyone!!

Here is a question from me whether a custom relationship[Related list] with a query to a table with 1 lakh records will affect the system performance. 

And if the related list lists out more number of records to the case form, does it affects the performance.

And how indexing the corresponding field will help the performance.

Thanks!!
Ramkumar Thangaraj

[Community Alums]

Hi @Ramkumar Thanga ,

By Default, all related lists load at the time a Form loads.  ie: before rendering the form to a user, every related list query has to first run.  Once all the data has been queried, THEN the form is presented to a user.

Similar to the rowcount setting, there is also another variable that can be set: ‘glide.ui.defer_related_lists'.
This loads the related lists after the form has loaded.

This can greatly increases the response time of forms.
By setting related lists to load after a form loads, the user will almost immediately see the form data, and by the time they scroll down to the related lists they are likely to be have loaded in the background.

You can easily test this recommendation by setting it to 'deferred’ for troubleshooting purposes, and for longer term health this can be se to “ondemand” so that related lists only load if the users clicks on the "load related lists" button.  
This is a true / false setting. 

You can set properties at the global level, which are then overridden by the user preference (if a user has explicitly chosen a different setting).

i. Go to the system properties, and see if it's set;
https://__INSTANCE__.service-now.com//sys_properties_list.do?sysparm_query=name%3Dglide.ui.defer_related_lists
- we can see ‘glide.ui.related_list_timing’ is not set.

To set the variable;
ii. click the NEW button, and give it a name of 'glide.ui.related_list_timing', of Type=string,
For the value, you have three options;
Value=default (loads inline with the form),
Value=deferred (loads AFTER Form loads), << select this
Value=ondemand (loads when the user clicks the button),
(leave all other values set (Application=global), then SAVE.
Now that if it is set, all users will pickup this setting moving forward (logout / login again)
This will not affect users that have made a choice and have a value set.

You can review those users (and update those users to also use ‘deferred') by visiting this link and bulk updating those records to ‘deferred / on demand';
https://__INSTANCE__.service-now.com//sys_user_preference_list.do?sysparm_query=name%3Dglide.ui.rela...

- also see: KB0695391 How to make 'After Form Loads' or 'On-demand' the default 'Related list loading' for all users?

https://hi.service-now.com/kb_view.do?sysparm_article=KB0750152

[Ramkumar Thanga]

Hi @Community Alums 

thanks for the reply .

default = with the form, deferred = after form loads, ondemand = On-demand

What is the difference between ondemand and default.