[wp-trac] [WordPress Trac] #16706: Queries using "category__and" are slow on large databases

[WordPress Trac]

#16706: Queries using "category__and" are slow on large databases
-------------------------+-----------------------------
 Reporter:  tigertech    |       Owner:  scribu
     Type:  enhancement  |      Status:  reviewing
 Priority:  normal       |   Milestone:  Future Release
Component:  Performance  |     Version:  3.1
 Severity:  normal       |  Resolution:
 Keywords:  has-patch    |
-------------------------+-----------------------------

Comment (by scribu):

 Indeed, we weren't talking about the same thing. Thanks for the
 clarification.

 I presume that {{{COUNT(1)}}} can be safely replaced with the more common
 {{{COUNT(*)}}}

 The question now is which is faster overall: the extra JOIN or your
 method.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/16706#comment:12>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software