[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:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Query         |     Version:  3.3.1
 Severity:  normal        |  Resolution:
 Keywords:  dev-feedback  |
--------------------------+------------------------------

Comment (by scribu):

 The only thing we can do here is add an index to the meta_value column.

 Since meta_value is of type LONGTEXT, the index needs to be limited to a
 certain length, which is up for debate.

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