Have you been wanting to fork me in the neck for a while, and are just now getting the chance to vent these feelings, Cindy?

I think we're getting a little ahead of ourselves. Can we please wait until Kristen finds out just how we're doing with FanGeek since we did the fixes and changed servers before we start figuring out how to obtain a lot of money that we may not need?

I think we're getting a little ahead of ourselves.

Sorry, DX. I wasn't breaking out my checkbook just yet, but I wanted to let peeps know that I'm prepared to do so.

You just don't want to see Allyson or I get a fork in the neck, do you? That's so sweet.

(DX - hide that barbeque fork - your cover is working)

Have you been wanting to fork me in the neck for a while, and are just now getting the chance to vent these feelings, Cindy?

(Only because I am dead to you, and then you could be dead to me, too. We'd be twins!)

Would you guys quit forking around.

Okay, so I got some news.

First off, we're doing better. But we're still not where we need to be.

1. Can we get rid of the random quote generator? It's definitely contributing to the problem. The day that we went down, they saw a bunch of quotes. Or maybe can we do it in another way that doesn't use any MySQL resources? I dunno. To me, personally, I can live without it for the sake of the board's health. I don't know how everyone else feels.

2. We discussed the persistent connection option. Steven doesn't recommend it. We can have more users online at once without it.

3. Yes, the connection should be closing the second the query is completed. There may very well be something glitchy somewhere in those miles of code that is keeping the connection open. We need to investigate this further.

4. It is also possible that the day we went down we were being heavily spidered by a search engine bot. Is there anyway we can block bots?

5. As of right now, there's no way to monitor our resource usage ourselves. But Steven is looking into some kind of utility that will let me monitor it. I'm hoping he finds something because I know I would feel better if I could watch the levels myself and not be jumping at shadows.

6. Y'all talk too much. Yeah, we can't really do anything about that one. I'm just saying. *snerk*

I think that's everything. Okay, it probably isn't but that's why god invented the edit function.

Now for my thoughts on the dedicated server issue...if you guys want to pool your resources and go that route, I'd certainly understand. Monique and I will refund whatever balance you have left and wish you well in a shiny new home.

That said, I'm not really convinced that you truly need a dedicated at this time. If your bandwidth usage was also high, it'd be a different story. But it's really just a resource issue right now, which says to me that this board can work in its current environment but we need to find a way to use the server's resources more efficiently.

1. Can we get rid of the random quote generator?

Kristen, do you mean the quotes at the top of the page or the BRQG, which is on a separate page? Or is that one housed on shrift's site?

First off, we're doing better. But we're still not where we need to be.

Can you be more specific? Did the changes help a lot? Just a little? How much?

To those who know more about coding than I:

Maybe we could code a Quote of the Day function? Every day at midnight, a job would run that would pick a quote at random and write it to a file. That file could easily be inserted into the upper right corner of our pages.

We'd still get random quotey goodness, but only once a day instead of with every page load.

t edit Brenda -- Kristen means the thing in the upper right.

Yeah, if losing the random quotes helps with the resource issue, I'm all for it. In fact, I already suggested it. Go me! :)

DXMachina "Buffistas Building a Better Board" Aug 3, 2003 4:29:15 pm PDT

Really, it's probably one of the least painful things we would have to do in the scheme of things. And Jon's suggestion for replacing it is a pretty good one. Wouldn't even have to be a random quote. Just pick the next one in line each day until you run out. The way randomization works around here, you might wind up with the same quote three days in a row.

Maybe we could code a Quote of the Day function? Every day at midnight, a job would run that would pick a quote at random and write it to a file. That file could easily be inserted into the upper right corner of our pages.

Even a quote an hour would be less of a drain than a new quote for ever user for every page hit.

But I'm more than happy to do without a new quote every refresh/page.

In fact, there have been a number of times that the quote caught my eye after I'd already clicked, and I would have liked to read the full quote, but once the page is gone, quote gone too, and I have to wait until the quote pops up again randomly.