It takes to much time to load records

ADIL9 · ‎08-26-2021

Hello,

I have an issue when trying to load records from change_request table based on filters that we fill using some fields.

the problem is when we click on submit, it takes a lot of time and apparently it scans the whole table instead of going direct to the specified filter.

is there a function or a way to minimize loading time?

Thanks,

Bhavana20 · ‎08-26-2021

Hello,

1)We also faced similar issue earlier, that was because we work in the domain seperated environment and in the backend there are too many records and hence we added the filter Domain is "Mycompany name" and the performance was improved, I am not sure whether this going to help but alternatively

2)under system definition ->Transaction quota rules , you can set the maximum duration time according to your requirement.

I am not sure if it helps you but post the right answer in the community if you found the solution.

Thanks,

Bhavna

View solution in original post

TJLillo · ‎08-26-2021

I worked with HI Support recently on instance slowness, and here's what the accepted response ended up being. Keep in mind that you can check your transactions to see what's most commonly being slow. See info below:

Cases where you can expect a slower loading time:
Loading unfiltered lists or filtering on non-indexed fields
	• At the very least, filter active=true
List views longer than the default of 20
Loading more than one list at a time
Dashboards with multiple simultaneously loading reports/widgets

A home page with a lot of stuff on it
	• Slower login time
	• Slowness for everyone during peak login times
	• Slower form submission
	• Homepage auto-refresh can make it worse
 
The following areas will impact the database performance which affects the overall instance performance
Loading unfiltered lists - Please refer #3 in [1] 
List views longer than the default of 20 - Please refer #1 in [1] 
Loading more than one list at a time - Please refer #12 in [1] 
Dashboards with multiple simultaneously loading reports/widgets - Please refer the following documentation on Performance Best Practice and homepage performance. 

[1] https://community.servicenow.com/community?id=community_blog&sys_id=dd6dea29dbd0dbc01dcaf3231f96190c&view_source=searchResult 

[2]https://community.servicenow.com/community?id=community_article&sys_id=0c3c6661dbd0dbc01dcaf3231f961947