use-the-index-luke.com
We need tool support for keyset pagination
Did you know pagination with offset is very troublesome but easy to avoid? 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.