How to solve performance issue of a list ?

[kozy_f]

My team built a custom table that 3 million records are populated.

When I try to open the list it takes 50 sec.

Watching at the browser reponse time I can see 46 sec are consumed on the Server side.
Is there any way to investigate the route cause and make the display time much faster ?

[Mike_R]

This is typical for tables with a lot of records.

As mentioned here,

https://www.servicenow.com/community/developer-forum/how-to-show-the-list-view-for-a-table-but-only-...

if you add ?sysparm_filter_only=true to the end of the URL, it will allow you to add a filter before attempting to load the list.