[wp-trac] [WordPress Trac] #20134: Performance Problems with Complex Meta Queries

[WordPress Trac]

#20134: Performance Problems with Complex Meta Queries
-------------------------+----------------------
 Reporter:  dominicp     |       Owner:
     Type:  enhancement  |      Status:  closed
 Priority:  normal       |   Milestone:
Component:  Query        |     Version:  3.3.1
 Severity:  normal       |  Resolution:  wontfix
 Keywords:               |
-------------------------+----------------------

Comment (by dominicp):

 In case it will help someone, I wound up using the `STRAIGHT_JOIN` MySQL
 optimizer hint on my complex meta query (in addition to taking scribu's
 advice on switching to taxonomies), and the performance was dramatically
 improved.

 I don't know why, and it might be a terrible idea in the long run, but I
 figured I'd post this in case anyone else can benefit. I've documented the
 results more fully on the StackOverflow question I referenced initially.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/20134#comment:5>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software