I am having these slow queries as well. the plugin is perfect and great but I keep getting lots of slow queries. of course i dont know how to optimize it and i m not here to criticize its author since he has done an excellent job. I am here to let him know that his plugin *maybe* has got some performance issue. Apart from this i love Simple Tags. The slow queries i am getting are the same as distobj. it took me a while to figure where they came from. Is anyone else having this issue? what can we do to solve it? Caching the blog? Limiting tags on posts? Any reply is very welcomed!
here are my slow queries:
Tue Mar 31 13:01:03 2009
# Query_time: 8 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT p.post_title, p.comment_count, p.post_date, p.ID, COUNT(tr.object_id) AS counter
FROM wp_posts AS p
INNER JOIN wp_term_relationships AS tr ON (p.ID = tr.object_id)
INNER JOIN wp_term_taxonomy AS tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id)
WHERE (tt.taxonomy = 'post_tag' AND tt.term_id IN ("71", "187", "3", "138"))
AND p.ID <> 2090
AND p.post_status = 'publish'
AND p.post_date_gmt < '2009-03-31 13:00:55'
AND p.post_type = 'post'
GROUP BY tr.object_id
ORDER BY counter DESC, p.post_title DESC
LIMIT 0, 6
# Tue Mar 31 13:02:21 2009
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2009' AND MONTH(wp_posts.post_date)='2' AND DAYOFMONTH(wp_posts.post_date)='9' AND wp_posts.post_name = 'blog article' AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC