📝 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...
Смотрите видео You’re Probably Doing Pagination Wrong онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Database Star 11 Июль 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,225 раз и оно понравилось 185 людям.