3 min read
Killing SQL_CALC_FOUND_ROWS on a 7-Million-Row Table
A WordPress admin screen took several seconds to load. The cause was one MySQL feature quietly scanning millions of rows on every page view - just to draw the pagination.
Tag
1 post
A WordPress admin screen took several seconds to load. The cause was one MySQL feature quietly scanning millions of rows on every page view - just to draw the pagination.