Most efficient way to sort table rows by "sys_updated_on"

[cc11]

Hi,

I have 800,000 incident records that I am try to pull using a GET rest api call.

My requirement is to sort them by "sys_updated_on" in descending order while querying.

I using the http parameter "sysparm_query=ORBERBYDESCsys_updated_on" in my REST end point but the query times out after 60 sec.

I dont want to increase the REST-Table-API timeout of the system.

Is there an efficient way to achieve this?

Thank you,

cc

[AirSquire]

Have you tried any of the solutions in the below 2 threads?

Get all data in single REST request - Solution by Harsh

How to get more than 10000 records in response of GET method in REST API

Regards
Air