Please Don't Use OFFSET and LIMIT For Your Pagination

Written by ivoecpereira | Published 2020/07/05
Tech Story Tags: programming | tech | coding | software-engineering | engineering | sql | performance | code | web-monetization

TLDR OfFSET and LIMIT are widely used for pagination in MVPs and low-data listings. But when you want to build reliable and effective systems from the scratch, you might as well do it right upfront. The higher your OFFSET, the longer the query will take the longer it will take. Instead of storing current OFFSet and LimIT locally and passing the query with the current key (usually an and the query) instead of the query, Cursor is called Cursor.via the TL;DR App

no story

Written by ivoecpereira | Chief Technology Officer @ Ongagement, Web & Mobile Applications Developer and Security Enthusiast
Published by HackerNoon on 2020/07/05