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

 This may not be the exact same query, but for something we were doing
 recently we had to create a new compound index that includes ID and
 post_type (http://screencast.com/t/dGDNzoSQceQk)

 Then used {{{ FROM wp_posts USE INDEX (post_type_id) }}} to force the new
 index to be used. It eliminated the temp table and improved query
 performances from 6 seconds to 0.32 seconds.  Using mysql 5.5.30

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