Table taking too long time to load the reacords

Para5
Tera Guru

Hello All,

We have one Time Worked table in the instance. This table consist of 2,776,766 of records.
When we try to open the table from the navigator it takes around more that 5 min to load all the records.

Is there chance or solution to minimize the loading time of records.
@Dr Atul G- LNG , @Maik Skoddow , @Danish Bhairag2 , @Anil Lande , @Ankur Bawiskar 

Any help appreciated,
Thank you. 

3 REPLIES 3

VS
Giga Guru

Hi,

 

I Would suggest you to use the tableName.filter instead of .list whenever possible, and use the condition builder to search for the specific record.

 

Thanks

VS 

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Para5 

 

These links will provide you some insights. 

 

https://www.servicenow.com/community/developer-articles/performance-best-practice-for-efficient-quer....

 

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

 

https://www.servicenow.com/community/developer-forum/it-takes-to-much-time-to-load-records/m-p/17412...

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Ankur Bawiskar
Tera Patron
Tera Patron

@Para5 

check these points

1. limit number of column displayed on the list, check below KB

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0786335

2. Check calculated fields and query time. Check the solution in the following thread.

What's the best way to investigate list view performance issues? 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader