Performance

This is preferred for handling large record sets because it provides better performance and scalability than offset pagination. With keyset pagination, results are ordered based on a unique identifier, and each page is defined by a range of values for this identifier. This allows for efficient retrieval of the required data without the need to scan through all records on every page request, as is necessary with offset pagination. As a result, keyset pagination is a powerful technique for improving the performance and scalability of applications that deal with large record sets.

Please Watch the video to learn more.