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. This is not an implementation problem, it’s the way offset is designed: …the rows are first sorted according to the <order by clau

[tgk]

offset句でpagenationしてはならない理由。1)パフォーマンス 2)ソート順位の高い位置にレコードが増減した場合、ページ送りしたら重複して表示されるor一度も表示されないデータが発生してしまう