[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:  new
 Priority:  normal       |   Milestone:  Awaiting Review
Component:  Query        |     Version:  3.8
 Severity:  major        |  Resolution:
 Keywords:  has-patch    |
-------------------------+------------------------------

Comment (by vprat):

 Replying to [comment:2 nacin]:
 > I think this overlaps with another ticket, but I can't locate it at the
 moment.

 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.

 The ticket you are looking for is
 https://core.trac.wordpress.org/ticket/24093 and has a patch too (probably
 a better one).

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