It’s rare that I ever think this, let alone say this, but I strongly agree with Liberal here. And DMC too (who I don’t know from Joe Poster anyway).
Even if you’re the bomb ass DBA and you can write optimized SQL statements until the cows come home, that has jack shit to do with how vBulletin works because you paid for vBulletin and it’s not up to you to rewrite the SQL.
If you’re a master at MS SQL and it runs all of your company’s internal apps and you’ve tweaked the performance to the realm of godliness, that still doesn’t mean you have the first clue as to how to make MySQL play nice on a Windows machine, or a Linux machine for that matter. You can go to any tech forum on the Internet and see all of the weirdness of which version of MySQL with which settings work or fail miserably on what machines.
You guys act like the Chicago Reader bought a dedicated Linux machine on which to install only Apache, MySQL and vBulletin, and they hired this guy named Jerry who’s a Linux and MySQL expert to do nothing but sit around and make sure that everything is working great.
The SDMB probably isn’t on a dedicated server. It may even be on a virtual server. It may be on a Windows server. Upgrading vBulletin might very well cause problems beyond what we’re experiencing now. Upgrading MySQL might do that too.
Jerry is most likely not a MySQL and vBulletin expert. He was definitely not hired for those skills. The SDMB is probably a huge thorn in his side that he begrudgingly takes care of just enough that it’s running most of the time. Whatever he was hired to do is actually more important to him AND his employer. And I am utterly amazed - gobsmacked - that he is cool enough to take a “board is down” page any time after 5 PM or on weekends. Having to do that probably makes him want to kill someone.
Yes, there are other boards that run better. If I was a Linux/Apache/MySQL guru and had a decent server I could probably make one that ran better. But I am not. Lots of boards you see that run without a hitch are probably on dedicated machines run by people who either set them up themselves for the express purpose of running a board (and chose vBulletin because they are most comfortable with MySQL and Linux), or they’re hosted on a mega-host that offers vBulletin hosting and has techs that specialize in making sure the shit runs right and is updated.
Could the SDMB be hosted elsewhere, perhaps on one of those specialized mega-hosts? Sure. But whoever paid for what is now in place probably does not want to “re-pay” for something they have already put money into. That’s just how businesses think. They also think about how data is such a goldmine right now (see Facebook, MySpace) and aren’t in a hurry to put all this data into someone else’s hands. Are they making a profit? Probably. Probably not much, though. No one’s going to make a move until the revenue can be proved to be enough to spend money AND have some left over. This is also how businesses think.
I’m sure I’ll get flamed for all of this, but I’m just amazed at how angry people get when the boards go down, when functions don’t work and people expect heads to roll.
I’ll tell you right now that I spend about 12 hours a day online - 8 at work and 4 on the SDMB exclusively. During those 8 hours at work, probably 3 are spent on the Dope throughout the day. I rarely go to any other sites on the Web - if I do, it’s from a link on the Dope. I also do not have extra money to spend on crap. I get pissed if I have to spend 55 cents on a can of beans instead of 50. Yet, $15/year (actually, $7.50 for me) seems like peanuts for the service the SDMB provides, whether it’s working or not. If it’s up, it’s up. If it’s down it’s down. I think “Jerry must be tearing his hair out, and all the kids at the SDMB are going to start whining.” I’ve never once thought about leaving, or wanting my money back, or any unfairness.
The level of uproar every time there’s a glitch just…it just boggles my mind. Chill.