No Offset Query12 Feb 2018
Life With out Offset
SELECT * FROM `table` WHERE id < ?last_seen_id ORDER BY id DESC FETCH FIRST 10 ROWS ONLY
This approach—called seek method or keyset pagination—solves the problem of drifting results as illustrated above and is even faster than offset.
Keyset vs Offset
Offset instructs the databases skip the first N results of a query. However, the database must still fetch these rows from the disk and bring them in order before it can send the following ones.