use of SQL_CALC_FOUND_ROWS needs to be eliminated
|Reported by:||_ck_||Owned by:||ryan|
|Cc:||aaroncampbell, Rand, HOPPE|
It's long overdue to rewrite a small part of query.php, eliminating the use of SQL_CALC_FOUND_ROWS and switching to COUNT(). Doing so will result in significant performance gains on active sites.
SQL_CALC_FOUND_ROWS has serious performance degradation issues and it's effects was even experienced on wordpress.org over two years ago before it was removed from bbPress.
More here with links to documentation and benchmarks:
My first rough attempt at a workaround that might be feasible:
Change History (12)
- Keywords dev-feedback added
- Milestone changed from Unassigned to 2.9
- Version set to 2.9