You’re Probably Doing Pagination Wrong
📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql...
Pagination, or the technique of writing code to show pages of results, is a common feature of databases and applications.
Recent databases include keywords that let you perform pagination queries, such as showing 10 results at a time or showing the 5th page of results.
However, there are a couple of things to be aware of and to consider implementing, and without these, your query could show incorrect results and have performance issues.
So, watch this video to find out what these issues are and how to implement the solutions.
⏱ TIMESTAMPS:
00:00 - How to do pagination
01:03 - Issue 1 - performance
03:49 - Issue 2 - ordering
🔗 VIDEO LINKS:
Scripts in this video: https://github.com/bbrumm/databasesta...
Watch video You’re Probably Doing Pagination Wrong online without registration, duration hours minute second in high quality. This video was added by user Database Star 11 July 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,225 once and liked it 185 people.