WP 2.0.4 - running terribly slowly! (64 posts)

  1. nomad1
    Posted 8 years ago #

    I thought I had tried deactivating all plugins, but now I've found out it's the Adhesive plugin that is slowing down the page load!

  2. oleg24
    Posted 8 years ago #

    I'm not sure if this problem is solved already, but there
    are some I did for my blog to make it faster.

    mysql>show full processlist \G
    You will get all the mysql processes which are currently running. If you see many lines about copying tmp tables,
    than smth is wrong.

    I had plenty of queries like:
    "SELECT DISTINCT * FROM wp_post ... GROUP BY wp_post.ID ..."

    As you can see in your mysql table definition ID is primary key, so you do not need to select DISTINCT. Also grouping by primary key gives nothing.

    This query makes mysql to create temporary tables.

    So you need to work around it.

    I simply removed DISTINCT from the query and Grouping by Id. This is may be not the correct solution, cause blog
    may loose some functionality, but I have everythig I need working.

    Also, this query uses "post_date", "post_date_gmt" and "post_status" when selecting data.

    But I couldn't find any indexes on that fields in my wp installation. So I created them.

    I have 16000 posts in my blog.

    Now WP works 2-3 times faster.

  3. shedd
    Posted 8 years ago #

    Disabiling Adhesive increased performance for my site. Is it possible that there's a conflict between this plugin and 2.0.4?

  4. chanzero
    Posted 8 years ago #

    hey oleg, in which file did you make those changes?

Topic Closed

This topic has been closed to new replies.

About this Topic