[Bb-trac] [bbPress] #665: SQL_CALC_FOUND_ROWS can do terrible things to large sites

[bbPress]

#665: SQL_CALC_FOUND_ROWS can do terrible things to large sites
----------------------+-----------------------------------------------------
 Reporter:  mdawaffe  |       Owner:                 
     Type:  defect    |      Status:  new            
 Priority:  high      |   Milestone:  0.8.3 & XML-RPC
Component:  Back-end  |     Version:  0.8.2          
 Severity:  major     |    Keywords:  bb_query       
----------------------+-----------------------------------------------------
 The WordPress.org support forums were brought to their knees by
 SQL_CALC_FOUND_ROWS.

 Many of the native functions don't need it either.  We already know how
 many topics there are in a certain forum, for example
 ($bbdb->forums.topics).

 Perhaps with the new BB_Query class, we can turn found_rows off by
 default.  The on switch could tell it to use either SQL_CALC_FOUND_ROWS
 and FOUND_ROWS() or COUNT (*) depending on which is more appropriate.

-- 
Ticket URL: <http://trac.bbpress.org/ticket/665>
bbPress <http://bbpress.org/>
Innovative forum development