Blog35.9K views2,794 votes0 replies1,415 following
Doctrine DQL Pagination: When OFFSET Slows Down and What to Use Instead
Doctrine's setFirstResult and setMaxResults work for early pages, but deep OFFSET pagination scans discarded rows. Learn when to switch to keyset pagination.
doctrine