Table taking too long time to load the reacords
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2024 01:03 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2024 01:08 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2024 01:10 AM
Hi @Para5
These links will provide you some insights.
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
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2024 01:38 AM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader