[Bb-trac] Re: [bbPress] #918: function get_forums causes excessive db queries

[bbPress]

#918: function get_forums causes excessive db queries
----------------------+-----------------------------------------------------
 Reporter:  _ck_      |        Owner:                    
     Type:  defect    |       Status:  new               
 Priority:  normal    |    Milestone:  1.0-beta & XML-RPC
Component:  Back-end  |      Version:                    
 Severity:  normal    |   Resolution:                    
 Keywords:            |  
----------------------+-----------------------------------------------------
Comment (by mdawaffe):

 MySQL can only use one index at a time, but that index may span multiple
 columns.

 {{{
 KEY `object_type__object_id__meta_key` (`object_type`, `object_id`,
 `meta_key`)
 }}}

 that index means we'll never do a full table scan if we look at, say,
 forum meta for forum_id = 1.

-- 
Ticket URL: <http://trac.bbpress.org/ticket/918#comment:1>
bbPress <http://bbpress.org/>
Innovative forum development