[wp-trac] [WordPress Trac] #20134: Performance Problems with Complex Meta Queries
WordPress Trac
wp-trac at lists.automattic.com
Mon Mar 5 23:07:37 UTC 2012
#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
More information about the wp-trac
mailing list