[wp-trac] [WordPress Trac] #24837: querying optimization for category AND searching

[WordPress Trac]

#24837: querying optimization for category AND searching
-------------------------------------+------------------------------
 Reporter:  robertv123               |       Owner:
     Type:  enhancement              |      Status:  new
 Priority:  normal                   |   Milestone:  Awaiting Review
Component:  Taxonomy                 |     Version:  3.6
 Severity:  normal                   |  Resolution:
 Keywords:  has-patch needs-testing  |
-------------------------------------+------------------------------

Comment (by wonderboymusic):

 no, you want to force the index so that `type` becomes `range` instead of
 `index`. http://dev.mysql.com/doc/refman/5.1/en/explain-
 output.html#jointype_range

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