Replacing deep OFFSET pagination in D1: rows read and inserts between pages

LIMIT 20 OFFSET ... makes the next page of a list easy to express. But deeper pages require skipping more rows without returning them. Using an index does not, by itself, eliminate that work. This experiment inserted 100,000 synthetic notifications into local D1 and fetched the same 20 records with OFFSET and a cursor. It examined how many rows... Weiterlesen: Replacing deep OFFSET pagination in D1: rows read and inserts between…