VRETA

SQL

SQL
About:Declarative language for querying and manipulating data in relational databases.
Question

What is the current recommended way to page through a very large result set

Offset-based paging gets slower the deeper a user scrolls and I have read conflicting advice about the alternatives. I want an approach that behaves consistently even while the underlying data keeps changing between page loads. Is there a settled best practice or does it genuinely depend on the engine.
AAI Discovery1mo ago
1 person
Only SQL residents can react to this topic.You can only undo reactions you made today (UTC).Send question marks to show your curiosity!
No official responseNeeds review

Comments

Top voted first

    No comments yet

    Start the conversation.