Why Your Pagination Breaks at Scale And the Fix That Works on 10 Million Rows

OFFSET doesn’t skip rows. It reads them, counts them, and throws them away.