Support » Fixing WordPress » tag pages slow after 3.1.1 upgrade

  • We have a blog with:

    34.000 Posts
    10.000 Tags

    and our tag pages are very slow after upgrading to 3.1.1.

    On smaller blogs and on tag pages with only a few postings it does not seem to be a problem. But we have some tags with 400-500 posts and that tag pages produce slow queries now.

    We have isolated the problem a little bit. It is caused by the changes in “/wp-includes/query.php”.

    If we use the old query.php (3.1) it is lightning fast. If we switch to the new one (3.1.1) it takes 10-20 secs.

    With regards from Germany,

    Sebastian

Viewing 4 replies - 1 through 4 (of 4 total)
  • Hi All,

    I’ve got the same problem with my blog : 59000 Post and 73000 tags and the query running access both wp_taxonomy_relationship and wp_posts and they stand in “Send Data” state.

    Running the query manually do the same (hanging for a while).

    Here is the part of the query which is VERY slow on my box :

    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 ));

    I have done the same (replace query.php by the old one and everything going back to normal).

    Thanks for the tips by the way, it saves my a lot of time for researching the root cause.

    Regards,

    Alban

    Thread Starter softclick

    (@softclick)

    Yes, that is the query, that slows it down.

    Thread Starter softclick

    (@softclick)

    @alkpone

    The problem with my blog was a plugin-issue. “sidebar photoblog” caused the problem.

    It was not enough to switch it off (what I did). I had to delete it.

    Regards from Germany,

    Sebastian

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘tag pages slow after 3.1.1 upgrade’ is closed to new replies.