4 ms·
OFFSET is not "handled by the engine". It heapsorts the entire dataset before you offset to a page. The top-level comment is asking for good ways to paginate.
by danneu 11y ago
OFFSET is not "handled by the engine". It heapsorts the entire dataset before you offset to a page.
The top-level comment is asking for good ways to paginate. OFFSET works on localhost and with hundreds of rows. My solution is one that works in production once OFFSET fails you. For me, it was day 2.
- seeing 11y agoIt was day 2 for you, with the specific engine you used. You don't need to heapsort the entire dataset before you offset to a page, and there are engines capable of doing this.