[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:  enhancement                          |      Status:  new
 Priority:  normal                               |   Milestone:  Future
Component:  Query                                |  Release
 Severity:  normal                               |     Version:  3.5.1
 Keywords:  needs-refresh meta-query needs-      |  Resolution:
  unit-tests has-patch                           |     Focuses:
                                                 |  performance
-------------------------------------------------+-------------------------

Comment (by vprat):

 Come on, that ticket is more than a year old and is derived from a 3 year
 old ticket that had an incomplete fix.

 Profiling data is pretty simple. A query with 6 meta query elements will
 simply never complete without the patch. When having 4 meta query
 elements, as said, it goes from a few minutes to a few milliseconds.

 Unit tests have been provided with the ticket referenced in the ticket of
 origin. I guess they are still valid.

 I was starting to consider dedicating more time to core fixes but if each
 patch I submit has to stay around for 3 years before it gets reviewed and
 committed, I'll just pass :(

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