Return to Support

Very slow database performance

Home Forums Graphene WordPress theme Support Very slow database performance

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #9862
    tonysab
    Member

    I am suffering very slow database performance times on my site radleyvillage.org.uk – this is apparantly since GoDaddy tightened up some of their resource allocations as I understand it. However whilst investigating this and running an SQL profiler it has shown consistently that the following query (invoked from the Graphene Theme) is hogging resources and taking a long time. Typically the following query is taking approximately 8 seconds –

    SELECT ID

    FROM wp_posts

    WHERE guid=’http://www.radleyvillage.org.uk/installer/wp-content/uploads/2014/04/20140406_K5S1732_panorama.jpg’

    the feedback is that previously it would not have been so noticeable as it would have used resources from elsewhere on the server, but now that GD has tightened this up it is highlighting poor performing queries more.

    I would be interested in knowing if this query can be improved – or indeed if it has been – I’m running Graphene 1.9.2.

    Thanks in advance for any advice.

    #44769
    Syahir Hakim
    Keymaster

    The query you quoted is an extremely simple one it should be almost instantaneous. How many posts and uploaded images do you have on the site? Also, try performing the “optimize” operation on the database and see if that helps speed things up a bit.

    #44770
    tonysab
    Member

    Thanks for your quick response.

    I have tried optimising but no real benefit seen.

    The wp_posts table has about 6000 entries and there are 2200 images on the site.

    Thanks.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.