ramakrishnachunduri

Yup!.. though the issue is strange and harder believe the issue lies with servers like godaddy where timeout is limitted to less than that of the time database takes up to give the data.

Changing the hosting for this reason is pretty costly one and the original hosting provider might not payback to you.

The ultimate solution is to reduce the waitage on database

1. Reduce no.of.posts – Well i am not saying to remove any posts from your blog, actually wordpress changes all the revisions in db and when you were writing a large article you’ll end up with atleast 20 auto saved revisions. so in reedbird8’s case the 9000 records wouldn’t hurt the db much but 9000×20=180000 would do that. The plugin named Better Delete Revision will clear out and reduces the no.of.revisions to be same as actual no.of.posts. Personally on my website codeworth i use it and it cleared off 98 revisions till now in 45 posts.

2. Reduce No.of.Hits to DB – Sadly wordpress keeps requesting db each time when an user wanted to visit the page so if you got 100 regular visitors then the no.of.db requests is no.of.posts x no.of.visitors which is pretty high when no.of.posts and no.of.visitors were hiked.The plugins like WP Total Cache , WP Super Cache will addup server caching so that relative db hits is reduced.
Alternatively U can use php inclusion and move the post contents to standard php files so that the the content is popped from web server rather than the DB server. Ex : plain php is included into wordpress post

Hope these little tweaks would help to get the issue’s impact minimized.

Lastly even i use godaddy hosting service and fed up with their limitations (while they keep saying they were best 🙂 ) and started to look for alternative as my subscription is bought for 3 years.

[Moderated – discussion of hosting is not permitted on these forums]