[wp-trac] [WordPress Trac] #18105: Improve JOIN efficency of tax_query

[WordPress Trac]

#18105: Improve JOIN efficency of tax_query
-------------------------+------------------------------
 Reporter:  Otto42       |       Owner:
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Awaiting Review
Component:  Database     |     Version:
 Severity:  normal       |  Resolution:
 Keywords:  needs-patch  |
-------------------------+------------------------------

Comment (by marcus.downing):

 I don't believe this equivalence is true in all cases. It applies in the
 case listed, when the relationship is 'OR' and each taxonomy's condition
 is 'IN'. But it doesn't apply when the relationship is 'AND' or a
 taxonomy's condition is 'NOT IN'.

 In the cases it does apply to, this change provides a substantial
 performance improvement.

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