Howdy; I was another of the folks using the now-realized-to-be-evil YaBB on my site (interestingly enough, in a search I ran across several other webhosts who have far harsher anti-YaBB policies than Dreamhost--some involving disabling entire sites without warning). Like others, I went scrambling to find a replacement, and in the process came across YaBBSE.
YaBBSE (www.yabb.info--first .info domain I've ever used!) is a completely PHP/MySQL version of YaBB, has a more polished feature set than even Gold SP1, a familiar interface, and according to several posts I've read elsewhere is easier on servers than the Perl version. Since it was a very easy upgrade from YaBB (there's a converter that seemed to work almost perfectly), I decided to give it a go and see how it went.
So far, all seems to be well, and it certainly seems more responsive than the CGI version, but now I'm curious if it's really more efficient, and I don't have any frame of reference for comparison.
The only thing I do know is that the forum looks like it'll be averaging on the order of 8-10 million of those Conueries per month, with something like 300+ daily users, about 15 simultaneous users peak, and an average of 5000-10,000 clicks per day. This is within the limits of my Code Warrior plan, and the ratio of connections to queries is consistantly around 2.5 (which seems to be ok, or at least not horrific), but since Dreamhost said that those limits were generous, it seems like a lot. So, I'm not sure if my forum is just popular/active, or YaBBSE is still far less efficient than, say, phpBB or Ikonboard, and I'm not all that hot about trying to upgrade to find out.
So, I guess I'm asking two seperate questions: One, does anybody have specific experience with how YaBBSE is in terms of server load in comparison to other PHP forum software, and Two, what kind of Conuery traffic do other folks see on forums?
I'm guessing that enough people might be interested in moving away from YaBB (the Perl version) to make some information along these lines useful.