Page 500 is slow, and page 2 skipped a row

• A

  Keyset pagination; remember the last row seen and ask for rows after it

• B

  Add an index on created_at so that the offset can be skipped over efficiently

• C

  Cache each page so repeated requests are consistent

• D

  Use a smaller page size so offsets stay small