UBB.threads PHP Forum Software Community Forums General Suggestions and Feedback site slow last few days

I've noticed my forum site seems to be loading pretty slow the last couple of days. I emailed my hosting provider and they had me run a 'tracert' on it. They sent me back the following reply:

"We are unable to duplicate the issue that you have presented us. Sorry for any inconvenience. The trace route indicates your connection is reaching our servers. The speed issue appears to be related to the application your website is running. It is recommended that you optimize the database in your hosting account to improve load speeds. You can find a tool/application for optimizing your MySQL database by doing a search on any search engine."

Is there anything on my end that could be slowing things down? I just launched the site a few weeks ago. Why would I need to optimize the database? Thanks.

Do you have the debugging information turned on in the footer? If so, can you post a few of the stat lines, so we can get an idea if it's general cpu or mysql slowdown. What I'm referring to is:

Generated in 0.05 seconds in which 0.01 seconds were spent on a total of 15 queries. Zlib compression enabled.

Rick, I pasted it below:

Generated in 6.282 seconds in which 0.741 seconds were spent on a total of 10 queries. Zlib compression disabled.

6.282 seconds is incredibly slow - care to share your link?

Well, if that's the typical stats, then it's not MySQL at all. From that line it's taking less than a second to run all of the queries, but it's taking close to 6 seconds to run the php code to process them. That looks more like a general server slowdown.

If it's MySQL related as your host stated then you'd see the second number taking up most of the time.

I would have to agree with Rick. I just got this when looking up the privacy link on the site.

louisianaoutdoors.com
208.109.78.142
linhost264.prod.mesa1.secureserver.net

Time to get a response from that server:
linhost264.prod.mesa1.secureserver.net. 416ms

I would have to think that there is something else besides your site issues going on there.

As an example here are the results from my site

kixhelp.com
205.234.190.58
205.234.190.58 PTR record: esc54.midphase.com
esc54.midphase.com. 29ms

.

I just got this one:
then a minute later:
Why is Zlib compression disabled?

I don't know, I've wondered about that...how do I enable it?

I just got the following stats:
Generated in 0.506 seconds in which 0.214 seconds were spent on a total of 15 queries. Zlib compression disabled.

Control Panel » Primary Settings » Advanced Options » Enable zlib Compression?

See if that helps...

Thanks, I'll give that a try. Also waiting back to hear from my hosting company.

Hmmm... well, it's not gonna help the server issue, but should help once that's cleared up...

It seems that I can't access my site at all now. After about 30 seconds of the page not loading I got a pop up window that asked me if I wanted to open or save the file:

You have chosen to open
ubbthreads.php
which is a: php Script

I'm on hold now with tech support for my web hosting provider.

How popular is the site? Have you considered running a dedicated server?

I can access it, but it's darn slow...

I have a premium shared hosting account. I just launched the site a few weeks ago. So far I'm encouraged by the feedback. I had debated about a dedicated server. If I keep having issues I may need to upgrade to that.

I just got off the phone with GoDaddy hosting and they confirmed the obvious (after first trying to tell me that everything seemed fine to them). They sent the issue to advanced hosting tech support and confirmed there is a loading issue and are working on it. I had to call them a few weeks ago about the slow server response so things are not off to a good start with their hosting.

Well this is a real security issue as your account credentials can be stored in PHP files. It should NEVER offer to save or open a PHP file for you. It should all be parsed by the server.

I don't know if you have 100 other sites or not, but your forum is no where near big enough to justify a dedicated server...

I'm on shared hosting w/ no problems -- and my forum is just one of about a dozen of my own sites on the server (as well as others' domains):

CP -> Master Settings -> Primary Settings -> General Tab -> Advanced Options -> Enable zlib Compression?

Have you read all the posts yet?

i swear, i clicked "show all posts" and it didn't load them all... how odd...

I wonder if there are any issues with space that
he has allocated for himself.

Bare in mind i havnt a clue.

Where do you think this problem is originating? From the server end or the script itself?

Apache on the Server. Did you actually open or save it and was it actual PHP code or was it blank or just html of your site?

I still say the SERVER is the one having an issue here not your site in general and not UBBT.

I agree with Geoff that you don't appear to need a dedicated or virtual private server (unless you have spare cash hanging around)

Hopefully a fluke and they'll have it fixed soon, if not then yes I'd look for a new provider.

I should have tried to open or save it but didn't. Hopefully there won't be a next time but if there is I'll try.

Looks like the site is loader much faster. Hopefully they've taken care of the problem.

I will agree that it doens't seem he's in need of a VPS due to size; i've seen much larger on sharedhosts using minimal resources.

Yes the site is humming along now like it's supposed to.

looking good from here as well - hopefully all your issues are resolved

Here's an interesting little story about my experience with Godaddy on this issue:

This morning the pages were taking a while (>20 sec.) to load up again. I called Godaddy again and they said the server had 5 times the normal load this am.

Well yesterday, in my frustration...well I wasn't that frustrated, but I read an article a couple of weeks ago about Godaddy founder, Bob Parsons, and he seems like a real take-care-of-business type of person. I decided to go to his blog and submit a comment about my experience the last few weeks with my hosting account. I submitted the comment on a totally unrelated blog entry of his. A few minutes ago I received a phone call from a nice fellow, (his name escapes me right now) who told me he read my blog comment and read my emails about my problems. He told me they were going to relocate my site to another server. If I had any more problems I could email him at president@godaddy.com.

So I'm impressed and now they've probably got a customer for life. I've used them for a couple of other sites and have been pleased. Any way I just thought I'd share this story and commend them for taking care of their customers.

lol the owner probably called up support all "this guy is posting on my personal blog that he's angry with our serfvice levels, move to a new server stat"

indeed - sadly that server will probably be fine, until they fill it with hundreds of other accounts that hit the server hard....

The Blog search is on...

Happy its been resolved,
funny if you have ever ring support you can begin with,


"The President Said" lol
Get a screen shot of his reply
And us it as a signature for Support...

Yeah that would fly about once or twice if at all.

exactly

[deleted]