links.md

Useful Links

1. Pagination in MySQL for bigger databases using late row lookup

SELECT  l.id, value, LENGTH(stuffing) AS len
FROM    (
        SELECT  id
        FROM    t_limit
        ORDER BY
                id
        LIMIT 150000, 10
        ) o
JOIN    t_limit l
ON      l.id = o.id
ORDER BY
        l.id

---

Source: https://explainextended.com/2009/10/23/mysql-order-by-limit-performance-late-row-lookups/