Improving SQL Pagination Performance with UNION ALL

Paginating Large Datasets with Pandas and Django: A Guide to Column-Based Pagination