[wp-trac] [WordPress Trac] #24093: WP_Meta_Query is inefficient when referencing the same keys in "OR" query

[WordPress Trac]

#24093: WP_Meta_Query is inefficient when referencing the same keys in "OR" query
-------------------------------------------------+-------------------------
 Reporter:  sc0ttkclark                          |       Owner:
     Type:  defect (bug)                         |  boonebgorges
 Priority:  normal                               |      Status:  accepted
Component:  Query                                |   Milestone:  Future
 Severity:  normal                               |  Release
 Keywords:  meta-query needs-unit-tests needs-   |     Version:  3.5.1
  patch                                          |  Resolution:
                                                 |     Focuses:
                                                 |  performance
-------------------------------------------------+-------------------------
Changes (by boonebgorges):

 * keywords:  needs-refresh meta-query needs-unit-tests has-patch dev-
     feedback => meta-query needs-unit-tests needs-patch
 * owner:   => boonebgorges
 * status:  new => accepted


Comment:

 I've been thinking about this some more, and I think I've come up with a
 technique for consolidating JOINs that is along the lines of what I've
 laid out above. See #18105 [29902] for how it works in `WP_Tax_Query`. The
 check for "compatible aliases" will be more complicated here. I'll write
 some unit tests and see what I can do about a patch.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/24093#comment:32>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform