[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:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Query         |    Version:  4.8
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 Hi,
 Recently I am working on a project in which i have to handle the complex
 data based on post metas. I needed to query the posts with multiple pairs
 of meta key and values and both joined by AND while same meta key can also
 contain different values in database. So when query reaches up to 10 joins
 of MySQL for postmeta table it gets too slow to respond, you can check by
 the case i described and if you feel no problem then let me know so I can
 send you the query request.

 I am also trying to find its solution, but can't succeeded yet.

 Have a great day,
 thanks.
 Majid

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