[tonysab]

tonysab

#9862

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.

[Syahir Hakim]

Syahir Hakim

#44769

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.

[tonysab]

tonysab

#44770

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.