Revamp MySQL Query Optimization and Overcome Slowness of ORDER BY with LIMIT Queries
Percona
DECEMBER 21, 2023
Looking at this, can you say which is faster: LIMIT 1 or LIMIT 10 ? Presumably, fetching fewer rows is faster than fetching more records. This optimization is performed by default whenever the optimizer determines that using it would allow for faster query execution. Hopefully, MySQL will be adding this in the upcoming releases.
Let's personalize your content