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

 * version:   => 4.1


Comment:

 Replying to [ticket:30044 boonebgorges]:
 > First step toward this would be to see some benchmarks using data of
 different kinds: small databases; large sets of posts with relatively
 small postmeta tables; large sets of posts with large amounts of postmeta.
 --

 Hello all, I am writing cause I saw that you need to test this on sites
 with large databases – or at least that’s what I understood. I own a
 wordpress-based site which currently has 46.524 Posts and 431.935 Comments
 (let me know what other stats you’d need). If you’d like to apply the
 patch and get any performance metrics before and after let me know and
 I’ll help as much as I can.

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