Community Article

Pagination Strategies: Offset, Cursor, and Keyset

Offset is the default that breaks under load. Keyset is what you want for most lists. Cursor is keyset wearing a public costume. Pick deliberately, not by ORM defaults.