Getting orders by bulk operation: Unusable slow

GraphQL Admin API Troubleshooting
1

Hi, we are facing an issue where we want to get orders and line items for a given time period (filtered by updated_at). For one of our clients it takes over an hour to get the the data for a time period of 3 hours (around 5000 order). For other clients we are able to pull even multiple days at once with even more orders in the time frame (like 20000).

Have your ever experienced this kind of slowness? What can i do to optimize (we are already using sortKey)?

For me it feels like either the orders query does not scale linear or something is wrong with the client.

2

Is the request faster without the sort key? If you are getting them in bulk presumably you don’t need them ordered in certain way?

What is the exact filter you are using?

3

No, i don’t care about order, but the documentation states that this would be one way to speed up slow operations.

Example query: orders(query: "updated_at:>='2025-03-01T00:00:00Z' AND updated_at:<='2025-03-01T02:59:59Z'", sortKey: UPDATED_AT) {}