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

WordPress Trac wp-trac at lists.automattic.com
Tue Jul 19 12:40:57 UTC 2011

#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

More information about the wp-trac mailing list