[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):

 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:3>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform