Why You Shouldn’t Use OFFSET and LIMIT For Your Pagination

Ivo Pereira
The Startup
Published in
5 min readJun 17, 2020

--

Gone are the days when we wouldn’t need to worry about database performance optimization.

With the advance of times and every new entrepreneur wanting to build the next Facebook combined with the mindset of collecting every possible data-point to provide better Machine Learning predictions, we, as developers, need to prepare our APIs, better than ever, to provide…

--

--

Ivo Pereira
The Startup

CTO at Ongagement, Entrepreneur, Full-Stack Applications Developer and Security Enthusiast