X on X

use-the-index-luke.com

Partial results: getting rows X to Y efficiently

Pagination is a common requirement for web-apps. OFFSET is popular, but has many drawbacks.