WP 2.0.4 – running terribly slowly!

  • Hi, I don’t know if there’s any solution to this, but it’s worth a try.

    Last night I upgraded an intranet (hence can’t give URL, sorry) to the latest version of WP, v 2.0.4. I cut down on the plugins I’ve been using for the last three versions, but my site is now running like a snail on tranquilisers.

    I’ve dropped some redundant SQL database tables, I’ve optimised the SQL database, and I’ve disabled plugins which aren’t strictly necessary to the functioning of my site. I’m using a very plain theme with no graphics which I haven’t changed for a long time, so I doubt it’s that which is causing the problem. I’ve even installed a WP-Cache plugin, which seems to be helping a little, but not enough.

    I’m really loath to get rid of any plugins as I figure I really need the ones I’ve got – they’ve worked fine with all the older versions of WP I’ve used so far.

    Can anyone suggest anything else I can do to speed things up other than disabling plugins? I’d love to hear any ideas because this lag in speed is driving me nuts!

    Many thanks,
    Kind regards,
    Croila

Viewing 3 replies - 61 through 63 (of 63 total)

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

    First.
    Run
    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.

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

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

Viewing 3 replies - 61 through 63 (of 63 total)
  • The topic ‘WP 2.0.4 – running terribly slowly!’ is closed to new replies.