One of the most asked interview question these days : An API returns 1 M records , how would you design pagination ?

@SumitM_X Offset-based pagination for large data not good so I used Instead of page numbers, use a cursor (last seen value). after that I used index to db