Personally, if the loss of the random quote generator cut our resource usage in half, I'd have no objection to the quotes becoming a thing of the past. It was a nice feature, but I'd much rather we lose something that's essentially an accent than have to make major changes to board setup and people's posting/reading habits.

Yes. It was nice, but it's not like most of us don't randomly think of, and/or spout out Buffy and Angel quotes all day, anyhow.

First off, thanks for all the thanks and all, but this was 99.999999% Kristen's work. She's the point person for the Buffistas account in the global enterprise known as FanGeek. I'm backup.

Second, those of you advocating turning on the random quotes generator make a good point about wanting to know what exactly caused the problem. However, and I hate to sound all Doom and Gloomy, but if you turn it back on and usage again skyrockets, we (the FanGeek we) can't guarantee that we'll be able to get the board back up in anything resembling a timely fashion should our Web hosts decide that usage is unreasonable and suspend Buffistas.org again. I also don't think it's fair to the other accounts on the server to ask that one account that has been known to have overage issues be allowed to possibly triple or whatever its allotted MySQL connections again for a test, even if it were a short one. To be blunt, we're lucky they didn't HostRocket you. I'd rather not test the limits of Steven's generosity.

If anyone were to ask me -- not that anyone has, but when has that stopped me? -- I'd say you've done an amazing, excellent job so far of cutting down resources. Breathe a little easier than you may have for the past week. I'd rather you post in a somewhat normal fashion, while keeping in mind things you can do to help conserve usage, than a large number of people be posting only when absolutely necessary and we get whalloped come the start of the fall TV season.

On the same note, keep thinking long-term. I'd recommend continuing to check through the code if people are willing to do so, and going ahead and implementing the housekeeping changes people are voting on now. You've gone through all the trouble of the discussion and the voting, and if the board feels things can be consolidated, by all means, take advantage of things and the situation will be that much better off come fall.

I'd rather you post in a somewhat normal fashion, while keeping in mind things you can do to help conserve usage, than a large number of people be posting only when absolutely necessary and we get whalloped come the start of the fall TV season.

Ooooh, good point.

Thanks to the coders and unloaders and everyone who helped reduce the strain on the board.

I am 99.5% sure it was the quote generator.

Good enough for me.

I'd rather you post in a somewhat normal fashion, while keeping in mind things you can do to help conserve usage, than a large number of people be posting only when absolutely necessary and we get whalloped come the start of the fall TV season.

I think this is really important. The worst thing would be the board crashing during a watch'n'post becuase everyone was too conservative now.

Cookie cookie cookie starts with "C"!

sorry

I am 99.5% sure it was the quote generator.

But since we don't know *why* the quote generator caused the problem, we'll probably cause the same problem with the next feature implemented.

It would really pay to get to the bottom of this.

I'd be happy to look at the source code. I can probably even run it on my system at home, since I just installed MySQL and PHP for another reason.

Anyone who wants to do some investigating into this phenomenon off the server in their own time is more than welcome to. Insights will certainly be appreciated.

> If you want the list, either e-mail me, or I can post it again: basically, it says "CVS repository; Move search out of beta (

The list is at Am-Chau Yarkona "Buffistas Building a Better Board" Jun 26, 2003 6:41:51 am PDT. Isn't CVS a done deal? I thought that Rob got it set up and ready to use, based on ita "Buffistas Building a Better Board" May 9, 2003 4:05:12 pm PDT. Would the CVS let us, for example, roll back the change we made by adding explicit closes to all the functions, without touching the other changes we made since then? That would be handy at times like this.

Anyone who wants to do some investigating into this phenomenon off the server in their own time is more than welcome to.

Jess PMoon, Liese S, and I think Michelle T were looking at the SQL code. Rob, ita asked them to drop her a line at her profile address so she'd know where to send it, or maybe you could ask one of those three to forward you a copy.