[wp-trac] [WordPress Trac] #14090: the_tags never caches

WordPress Trac wp-trac at lists.automattic.com
Sun Dec 5 02:51:19 UTC 2010


#14090: the_tags never caches
-------------------------------+--------------------------------------------
 Reporter:  luke83             |        Owner:          
     Type:  defect (bug)       |       Status:  reopened
 Priority:  normal             |    Milestone:          
Component:  Taxonomy           |      Version:  3.0.2   
 Severity:  normal             |   Resolution:          
 Keywords:  reporter-feedback  |  
-------------------------------+--------------------------------------------
Changes (by EPANETWP):

 * cc: EPANETWP (added)
  * status:  closed => reopened
  * version:  3.0 => 3.0.2
  * resolution:  invalid =>


Comment:

 Hi guys,
 I´ve having a simular issue.
 MySQL is giving slow queries like these:


 {{{
 # Sat Dec  4 13:07:33 2010
 # Query_time: 2.471577  Lock_time: 0.061732 Rows_sent: 4  Rows_examined:
 22
 use espaland_wrd3;
 SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON
 tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON
 tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN
 ('post_tag') AND tr.object_id IN (1878) ORDER BY t.name ASC

 # Sat Dec  4 13:07:39 2010
 # Query_time: 2.743471  Lock_time: 0.051083 Rows_sent: 1  Rows_examined: 9
 use espaland_wrd3;
 SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON
 tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON
 tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN
 ('category') AND tr.object_id IN (1718) ORDER BY t.name ASC
 }}}

 blueHost is CPU throttling my account becasue of few bunch of queries like
 that.

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


More information about the wp-trac mailing list