• Hello, the home page of my site http://www.discodamaged.com is very slow to load. I got the following from my ISP when I asked if they could help me work out the slow loading speed –

    I would note that your discodamaged.com WordPress install appears to have a potential coding issue as a query being made against its wp_posts table is regularly taking a very long time to complete, an example of the query in question is:

    # Time: 140619 16:37:32
    # User@Host: discodam_wp3[discodam_wp3] @ localhost []
    # Query_time: 178.758675 Lock_time: 0.000143 Rows_sent: 10 Rows_examined: 235619
    SET timestamp=1403192252;
    SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, IF (wp_posts.post_type = ‘tribe_events’, wp_postmeta.meta_value, wp_posts.post_date) AS post_date, tribe_event_end_date.meta_value as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta as wp_postmeta on wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = ‘_EventStartDate’ LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND wp_posts.post_type IN (‘post’, ‘tribe_events’) AND (wp_posts.post_status = ‘publish’) GROUP BY IF( wp_posts.post_parent = 0, wp_posts.ID, wp_posts.post_parent ) ORDER BY post_date DESC LIMIT 0, 10;

    Various discussions on WordPress’ forums indicate slowdowns in this query are typically caused by a combination of a very large number of rows in the wp_posts table (your install currently has over 14,000 posts which as above equate to over 235,000 rows being checked when the above query is being performed) and faulty plugins, you may therefore wish to check these.

    I have disabled plugins one by one, and none of them makes a difference, so I’m now trying to work out how to remove old posts to an archive. Is there a way to split my blog into several parts so that it doesn’t query the entire database each time?

    Or can someone suggest an alternative solution to the slow home page loading (the other pages load fine, as does my other site which is hosted on the same server).

Viewing 9 replies - 1 through 9 (of 9 total)
  • Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    That query is from http://wordpress.org/plugins/the-events-calendar/ so I’m surprised it didn’t speed up when you deactivated that plugin. Did you indeed deactivate that plugin?

    Approximately 22% of the internet uses WordPress (the entire internet), including many professional news sites with years of posts, so it really has nothing to do with your amount of posts, unless your hosting provider isn’t all that reliable. 😉

    Try disabling The Events Calendar plugin again, just to see if that makes any difference. After all, it should, because it won’t run the query that your ISP flagged as being too slow. 🙂

    Thread Starter els76uk

    (@els76uk)

    Ah yes, thanks James. I wasn’t paying attention and had missed that one. So when I deactivate that plugin, the page loads instantly, but I get presented with a home page devoid of any stories.

    It’s meant to look like this but when the plugin is deactivated, it looks like this.

    I note that the wordpress top bar doesn’t load either.

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    And that happened only by disable the “The Events Calendar” plugin? Very odd, but perhaps all of your posts are events, and therefore don’t exist without the plugin.

    I recommend posting at http://wordpress.org/support/plugin/the-events-calendar so the plugin’s developer and its support community see this, or if you are a user of Events Calendar Pro, it looks like http://tri.be/support/forums/ is the best way to reach them.

    Thread Starter els76uk

    (@els76uk)

    Thanks James, just done that. My posts definitely aren’t all events, but hopefully they can help me get to the bottom of it.

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    Just a thought, are all of the posts still gone if you switch to the Twenty Fourteen theme with the Events Calendar plugin still disabled?

    Thread Starter els76uk

    (@els76uk)

    No, they reappear. Does this mean I have an issue with my theme, or the plugin?

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    Possibly a problem with the theme now that you mention it.

    Do you have the same slowness with the plugin enabled again and the Twenty Fourteen theme?

    Thread Starter els76uk

    (@els76uk)

    I do, yes. With plugin enabled and 2014 theme, the home page won’t load.

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    Ok, so it’s likely a combination of both then.

    At them moment, I’d recommend that you start by asking the Events Calendar folks for help with the plugin.

    Once you get that fixed, see if the theme works again. If not, time to contact the theme’s designer.

    For now, just continue to use the Twenty Fourteen theme (or pretty much any other theme from https://wordpress.org/themes/ ) with the plugin off.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Blog's too big – how to split into parts’ is closed to new replies.