SQL Seek Method or Keyset Pagination

SQL Seek Method or Keyset Pagination

摘要

In this article, we are going to see what the SQL Seek Method or Keyset Pagination is and why you should consider it when navigating over large results sets.

The goal of pagination is to avoid fetching large volumes of data since the UI has a limited viewport that could be used to display data.