[wp-trac] [WordPress Trac] #17075: tag pages slow after 3.1.1. upgrade

[WordPress Trac]

#17075: tag pages slow after 3.1.1. upgrade
--------------------------+-----------------------------
 Reporter:  softclick     |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Taxonomy      |    Version:  3.1.1
 Severity:  normal        |   Keywords:  needs-patch
--------------------------+-----------------------------
 http://wordpress.org/support/topic/tag-pages-slow-after-311-upgrade

 Changes in /wp-includes/query.php make tag pages very slow, if there are
 many tagged posts.

 Slow Query:

 SELECT SQL_CALC_FOUND_ROWS wp1_posts.* FROM wp1_posts WHERE 1=1 AND (
 wp1_posts.ID IN (select object_id from wp1_term_relationships where
 term_taxonomy_id in (754,281) GROUP BY object_id HAVING COUNT(object_id) =
 2 ));

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/17075>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software