[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)                         |      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 dev-feedback              |     Focuses:
                                                 |  performance
-------------------------------------------------+-------------------------
Changes (by sarukuku):

 * keywords:  needs-refresh meta-query needs-unit-tests has-patch => needs-
     refresh meta-query needs-unit-tests has-patch dev-feedback
 * type:  enhancement => defect (bug)


Comment:

 There's no metion of a limit in the WP Meta Query class reference. The
 meta_query implementation creates so bad SQL that it actually can cripple
 the whole server with only 9 compares. I think the type of this should be
 changed to bug.

 In general I also feel that it's weird that the meta_query implementation
 differs so much from the taxonomy_query implementation (f.ex. missing the
 support for multi level query with different compares).

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