Скачать с ютуб Pagination in MySQL - offset vs. cursor в хорошем качестве

Pagination in MySQL - offset vs. cursor

📚 Learn more about PlanetScale at https://planetscale.com/youtube. —————————————————— Blog post on pagination: https://planetscale.com/blog/mysql-pa.... Video on deferred joins: https://planetscale.com/learn/courses.... Article on deferred joins: https://aaronfrancis.com/2022/efficie.... —————————————————— 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:   / planetscaledata   • Discord:   / discord   • TikTok:   / planetscale   • Twitch:   / planetscale   • LinkedIn:   / planetscale