[Bb-trac] Re: [bbPress] #957: tag cloud makes separate mysql query for every single tag

[bbPress]

#957: tag cloud makes separate mysql query for every single tag
----------------------+-----------------------------------------------------
 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 _ck_):

 The extra queries may be caused by this first query failing, perhaps
 'bb_topic_tag' was meant to be $bb_topic_tag or some other string of comma
 delimited numbers?

 {{{
 SELECT t.*, tt.* FROM bb_terms
 AS t INNER JOIN bb_term_taxonomy
 AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy
 IN ('bb_topic_tag')  AND tt.count > 0
 ORDER BY tt.count DESC LIMIT 40
 }}}

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