[wp-trac] [WordPress Trac] #41219: WP_Query gets slow down with multiple meta query combinations

[WordPress Trac]

#41219: WP_Query gets slow down with multiple meta query combinations
--------------------------+------------------------
 Reporter:  babatechs     |       Owner:
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:
Component:  Query         |     Version:  4.8
 Severity:  normal        |  Resolution:  duplicate
 Keywords:                |     Focuses:
--------------------------+------------------------
Changes (by boonebgorges):

 * status:  new => closed
 * resolution:   => duplicate
 * milestone:  Awaiting Review =>


Comment:

 Hi @babatechs - Welcome to WordPress Trac!

 The slowness of these sorts of queries is pretty well documented. The meta
 tables are not really designed to serve as advanced filters of this sort;
 if you need to do extensive filtering by metadata, it might be better
 suited for a taxonomy (which generally scales better if used correctly).

 That said, we're looking at alternative strategies for AND queries in
 #30044. Please follow that ticket, and join the conversation if you have
 data or ideas to move things forward. Thank you!

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