[wp-trac] [WordPress Trac] #26281: Optimizing meta_query generated SQL? -> 9s to 20ms

[WordPress Trac]

#26281: Optimizing meta_query generated SQL? -> 9s to 20ms
-------------------------+------------------------
 Reporter:  vprat        |       Owner:
     Type:  enhancement  |      Status:  closed
 Priority:  normal       |   Milestone:
Component:  Query        |     Version:  3.8
 Severity:  major        |  Resolution:  duplicate
 Keywords:  has-patch    |
-------------------------+------------------------
Changes (by nacin):

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


Comment:

 Replying to [comment:3 vprat]:
 > Apparently, the optimisation would not be valid for AND relation.
 However, this is perfectly right for OR relation.
 >
 > So I guess just writing a special case for the OR relationship (in which
 case just use a single JOIN) would do the trick.

 Indeed, on all counts! Feel free to jump in on #24093 if you can help.

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