Lists with Millions of records either gets transaction cancellation or taking very long time to load.

[VaranAwesomenow]

Issue : Lists with Millions of records either gets transaction cancellation or taking very long time to load.

Try following

1. Remove pagination on the lists.

    link to steps : https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/list-administration/task/omit-record-count.html

2. Check if there are any records in sys_user_preference for that table with user = empty and delete them

    sample link : https://<instancename>.service-now.com/sys_user_preference_list.do?sysparm_query=nameSTARTSWITHsn_prd_invt_product_inventory%5EuserISEMPTY&sysparm_view=

    replace name with table name that you are seeing issue or remove the name filter and see if there are records that match table name that is having issue.

3. Check if there are any modules that open lists and if those modules have any sort criteria on them and remove them.