How to speed up lists on large tables

ceskie
Kilo Guru

‎04-22-2022 04:53 AM

Ahoy, we are one of the numerous tenants on an instance and our users are complaining that some lists take too long to open (30-60 sec per page load). Proper indices are already in place. The fact is that our affected tables inherit from task and there are currently 40 M records in task table, and many customizations. Any ideas how to speed up the performance? As I said, I don't think new indexes would help and task archive rules are also out of the game (table exists for 2 years and users still need all records there). Is it just "what it is" and users must wait a minute for each page load or is there anything we can do? Thank you

Labels:
0 Helpfuls
  • 2,161 Views
9 REPLIES 9

Community Alums
Not applicable

‎04-22-2022 05:06 AM

Hi @ceskie ,

By default, when a given list loads (in either Classic UI or Workspace), the page will display the total number of records in that list, along with a go-to-last-page icon.

When a list is built from a large table (we’re talking about potentially hundreds of thousands of records), it can take a long time to calculate the total number of records – especially if the list contains complex queries. In many cases, that total count may not be necessary information for the user.

I recommend having a look on the great articles written by the ServiceNow Performance Team: https://community.servicenow.com/community?id=community_user_profile&user=e2299eed1b305490d01143f6fe...

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

ceskie
Kilo Guru
In response to Community Alums

‎04-22-2022 05:17 AM

Thank you, we will definitely implement this! Docs - Omit record count in a list https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/list-admin...

0 Helpfuls

Community Alums
Not applicable
In response to Community Alums

‎04-23-2022 08:37 AM

Glad to see my answer helped you, Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

0 Helpfuls

cp11
ServiceNow Employee
ServiceNow Employee

‎04-22-2022 05:14 AM

Out of curiosity, have you done anything to prevent this message from showing up on your tables "Security constraints prevented displaying the records"? The standard message that appears when someone does not have access to records in a table?

0 Helpfuls