[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:  accepted
 Priority:  normal                   |   Milestone:  Future Release
Component:  Performance              |     Version:  3.1
 Severity:  normal                   |  Resolution:
 Keywords:  has-patch needs-testing  |
-------------------------------------+-----------------------------
Changes (by scribu):

 * keywords:  has-patch 3.3-early => has-patch needs-testing
 * type:  defect (bug) => enhancement


Comment:

 So, what's left are:

 * [attachmnet:16706.split.diff] - let `WP_Tax_Query::get_sql()` do the
 transformation from AND to IN
 * [attachment:16706.2.diff] - converts AND to extra JOINs

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