Pagination in MySQL - offset vs. cursor
September 7 2023, 2:03pm
📚 Learn more about PlanetScale at https://planetscale.com/youtube. —————————————————— Blog post on pagination: https://planetscale.com/blog/mysql-pagination. Video on deferred joins: https://planetscale.com/learn/courses/mysql-for-developers/examples/deferred-joins. Article on deferred joins: https://aaronfrancis.com/2022/efficient-pagination-using-deferred-joins. —————————————————— 00:00 Intro 00:12 How to pronounce paginate 00:30 The two pagination methods 00:54 We have bosses 01:25 Select * from people 01:45 Deterministic ordering 03:20 Limit/offset pagination 05:17 Shifting records in offset pagination 06:12 Cursor based pagination 08:13 Ordering by two columns 09:23 Cursor pagination drawbacks 09:53 Cursor pagination advantages 10:50 Summary of differences ——————————————————
💬 Follow PlanetScale on social media • Twitter: https://twitter.com/planetscaledata • Discord: https://discord.gg/pDUGAAFEJx • TikTok: https://www.tiktok.com/@planetscale • Twitch: https://www.twitch.tv/planetscale • LinkedIn: https://www.linkedin.com/company/planetscale/
