Should we just try to limit our posting? Or reading?

Yeah, I'm perfectly fine with just yanking the quote generator right now, if ita's all about the draconian. I say just go do it.

I mean, we still can't tell if that makes a big improvement in the number of SQL queries yet, can we? We're waiting for a tool maybe?

There's me - a day late and a dollar short, as usual.

Is there a specific post or series of posts you could point me to?

It all starts here: Kristen "Buffistas Building a Better Board" Aug 1, 2003 12:07:23 pm PDT This is my post following our account's temporary suspension.

The most recent information, based on my conversation last night with IH, is here: Kristen "Buffistas Building a Better Board" Aug 19, 2003 6:41:18 pm PDT

For those who don't want to wade through it all, let me sum up. Yes, we have a serious problem with the amount of server resources we are using. But there is a very strong possibility that this problem is fixable. We are working on a solution. Until that time, I am asking that we do nothing to increase the server load.

Thread spread kills servers dead.

But there is a very strong possibility that this problem is fixable.

Do we know if ita's recoding to make sure we closed SQL connections had any effect, are we in even slightly less dire circumstances?

We're in slightly less dire circumstances. The changes helped some. The new server helped a lot. It bought us some time. I'm hoping [*crosses fingers*] that the removal of the random quote generator cuts our usage in half.

At half, we'd still be at higher than acceptable levels but well within sight of meeting that goal.

But the down side seems to be that even if we do meet that goal, we're at a point where we can't put in any new threads without going dedicated.

We don't know that yet. Let's see what happens with the code. Someone could find a glitch and it could drop us far below our ceiling.

That would be happy-making for everybody invovled, I think.