Revamp MySQL Query Optimization and Overcome Slowness of ORDER BY with LIMIT Queries
Percona
DECEMBER 21, 2023
However, for 16 years since 2007, the MySQL query optimizer has had a “bug” that not only makes LIMIT 1 slower than LIMIT 10 but can also make the former a table scan, which tends to cause problems. I went through the case details for one of our clients last week, leading me to pen down this article.
100 
Let's personalize your content