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 –
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.
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.
The wp_posts table has about 6000 entries and there are 2200 images on the site.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic.
This free Support Forum relies on contributions from our support staffs and fellow Graphene themes users. While we endeavour to provide adequate and timely support, due to its voluntary nature responses are not guaranteed and may be delayed.
If you require urgent assistance, you may like to consider our Priority Support option.