Web site running slow

[nightshade]

not sure if something is wrong, but it has just taken forever to upload my hello to sharyn and then done a double,I have been upgraded to 4 meg by blueyonder so I do not want for speed!

[pxl8]

I've noticed some delays as well, I suspect it might be something to do with the SQL database based on past experience. I did check the routing and didn't see anything unusual there, even when I was waiting for pages to appear.

[Oy]

Maybe the database tables are carrying overheads and need optimising?

I run several sites using the same software as WAB - and I find I need to optimise the tables about once a month, especially on the big sites (20k members)

[StuartDH]

Thanks for the tip guys. We've been trying lots of things to sort the recent speed problems out, but totally forgot about optimising the tables

We've just optimised them, so fingers crossed it has done the trick.

[wildone]

For me now, almost instantanious. Thanks

[StuartDH]

Looks like the problem is still about, but it seems as though it's worst at certain times of the day - usually around noon and 7pm

Still can't work out why it's going wrong

[Oy]

Have you got any Cron jobs running at those times?

Or maybe it's simpler.... Lunchtime and after tea

If you're running on a shared server it may not be your site that's causing the slowdown.

[StuartDH]

No crons running.

We're on a VPS so we have are own allocated services on a shared server, so in theory we shouldn't be affected by other user accounts - that's the theory anyway

We seem to be getting a bad hit for about 15/20 minutes, and are load averages go right up, then suddenly everything is back to normal for 6 hours.

Everytime we get in touch with support, they just show us the load averages after the storm when everything is back to normal

[Oy]

I'd take a screen grab illustrating your server load and send that to them.

[nightshade]

Put them in touch with me, I am getting a blank screen in between forum jumps and it is still very slow
I have turned off firewall anti virus etc.I have 4meg so it is nowt I am doing

[StuartDH]

Our web hosts now assure us that it's something to do with the cache/accellerator software on the server, so they're installing a fresh copy. I'm not holding my breath.

[nightshade]

It has suddenly got a lot quicker,is this it now?

[Oy]

It's running a good as a good thing that got good here

[StuartDH]

We can only hope so. We've had a couple of spikes on the server's load throughout the day, which slowed things down a bit, but overall it has been a lot better.

[Oy]

It seems to be running like a corgi with a millstone round it's neck this morning

I'm getting 30sec - 1min delays between pages.

[StuartDH]

Sorry

The Gremlins were at it again last night and we had what was basically another blackout for the last 10 hours.

The company that provides our virtual server has let us down again and despite paying good for money for their supposed 99.9% uptime, this is the second major blackout this month.

[Pat]

I had a couple of hours to spare this morning and thought I'd have a really good look at everything and guess what, it's nearly 11-0am and I've only just got through, blank pages again.

[nightshade]

I thought you had decided to keep office hours Stu

[nightshade]

Wab disappeared yesterday ,this morning I only had the top 4 inchesof the page 3 refreshes before I got it all

[StuartDH]

Yesterday, the techies upgraded the system's Kernel (the thing that controls the processors) and it should have taken a few minutes, but ended up taking nearly an hour.

Not sure what the other problem is about, so we'll keep an eye out today and see if anything crops up.

Ta

Stu

[Pat]

Same here. Yesterday I got " page cannot be displayed " message for over an hour then this morning I got a blank page several times.

[Oy]

It's flying along now - fastest I've seen it

[Tamworth Weather]

WAB has always been slow for me and I am on a SuperJanet network. I put it down to the style on the forum templates. On the majority of days it just crawls along agonisingly slow, which is why I don't appear here that often.

What version of sql and php is being used by the hosting company - will it have an effect? Are you running any vB modifications or hacks that could generate extra queries?

[StuartDH]

Apache 1.3.34, Mysql 4.0.25, PHP 4.3.11 and eAccellerator

We've only got a couple of hacks and they're well used in the vB community with no signs of slowing forums down and it's same with the template.

Having said that, there's quite a bit of javascript in the template and latest threads info for the forum and front page, resulting in a page size of about 160kb, which could really do with being optimised.

The slow problems that we've been having over the past week or so look to have been caused by a fault in configuring the eAccellerator, but for the last few days we've been back to normal.

On every PC that I try the site on (all broadband) the pages appear within 2-3 seconds at the most. I'd be very interested to know why you're only getting crawling speeds - what browser are you using?

[Tinkerbell]

As mentioned by me in another thread, I am not experiencing this slowness, and neither is my local library where WAB links flew along this a.m.