Slow loading times on occasions

[birdy247]

Ok, this is a weird problem

I have a site hosted with Streamline.net

When interacting with the database sometimes the page will literally take about a minute to load and stop working. A message will then appear saying max time reached.

I dont understand why this is happening. Sometimes i can click through 100 pages and not have a problem with this. Order times after about 3 or 4 pages it will freeze up.

The weird thing is it says the timeout happened on line 6. Which is checks if the user is logged in. However, if i have an sql query on line 200, that obviusoly still works as my records get inserted into the DB.

Whos problem is this, my scripts or the streamline servers?

Seems weird that the only consistency is when it interacts with the database. Not on a particular page.

Any help would be nice!

[nutsaboutpayday]

Hi birdy,

I have having the exact same problem as you described.

I thought perhaps the issue is that my Wordpress site is hosted with Fasthosts, while the db it uses is on Stramline.net.

But your problem as described, plus my poor experience with Streamline.net generally, gives me a sneaking suspicious that the issue might be with Streamline.net themselves.

Have you discovered anything about this?

[birdy247]

Hi

I have done some googling, and it appears that quite a few people have said streamline has VERY slow SQL servers that can take upto 45 seconds to load or even not load at all.

I am guessing this is a common problem that streamline wont admit to. They have a section in their help pages that tries to deal with slow loading pages. Obviously they say if it happens, its our badly written code, not their servers!

I have had people check my code, and all say there is nothing that should make it freeze up like this.

End of the day, streamline sql servers just arnt upto the job!

[nutsaboutpayday]

Hi again,

(Sorry for the poor grammar in last message - I was sleepy!!)

I've done some googling myself and can summarise my research, but it's all pretty obvious:

"Database lag" is the number one factor affecting Wordpress sites' speed. The longer it takes for your database to respond, the slower Wordpress goes. How can you avoid slow database performance? One way is to make sure your db and Wordpress installation are hosted by the same company and, ideally, on the same server.

Single-server configurations have another important advantage over running multiple servers: Reliability. When you have two servers to worry about, that's twice as many things that can go wrong. If either one crashes, your website will stop working until it's fixed. By eliminating one of the servers, you're potentially cutting your downtime in half.

Blah blah blah....

In my case, I was not prepared to fully blame Streamline.net for the slowness of my Wordpress site. I figured it probably had something to do with the fact that the front and back ends of the site were hosted not just on separate servers, but with separate providers!! However, from all the googling I (and you) have done, it seems highly likely that Streamline.net has problems of their own.