Links

• https://www.eversql.com/faster-pagination-in-mysql-why-order-by-with-limit-and-offset-is-slow
• https://stackoverflow.com/questions/63902699/limit-offset-performance-issue-in-mysql

Test

• The query of applications by team

• Result in production

• The query using ids

• Result in production

• The query with join ids