[moomoo11]

Interesting.

I've always opted for cursor pagination for client consumer APIs.

For anything "admin" or management type stuff, it runs into the same issues you mentioned. In that case, I'd used application level queues and it took a long time for things like exports and what not.