[wp-trac] [WordPress Trac] #30044: Use subqueries for AND clauses in WP_Meta_Query

[WordPress Trac]

#30044: Use subqueries for AND clauses in WP_Meta_Query
--------------------------+-----------------------------
 Reporter:  boonebgorges  |       Owner:
     Type:  enhancement   |      Status:  new
 Priority:  normal        |   Milestone:  Future Release
Component:  Query         |     Version:  4.1
 Severity:  normal        |  Resolution:
 Keywords:  needs-patch   |     Focuses:  performance
--------------------------+-----------------------------

Comment (by haydenkshaw):

 Hello. Just thought I'd bump the issue as I've had to take an altenative
 approach with a plug-in I'm developing based on this limitation.

 I found that my page response time would jump from a couple seconds to 3
 minutes once I had 9 seperate Meta_Query keys that were compared in the
 following way:
 {{{
 OR(key1, AND(key2, key3), AND(key4,key5), AND(key6, key7), AND(key8,
 key9))
 }}}

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