My sentiments exactly. Other than the session variable issue, extensive use of subquery's to pull up those little counts of messages, and dare I say, looping over select query's, absolutely kills performance once it gets big enough. We (or one of clients to be specific) have the dev edition as well, and one week I sat down and optimized it to the point that I would put it up against phpbb and could feel confident about it winning. I ended up almost rewriting every query, and all the logic to do it though. Still love the interface though...it's great.
IMO it's still the best cf forum software as far as features vs price go though for a small site. A quick look at the SMB source shows that while it could use some work (precalculating those counts for starters), it looks less bloated, and would probably perform better out of the box. -- jon mailto:[EMAIL PROTECTED] Thursday, December 26, 2002, 5:50:51 PM, you wrote: BD> We have the developer version of that (although it may not be the current BD> version) here. It allows unlimited copies on a single box -- edit the code BD> all you want as long as you leave the product info at the bottom. BD> Personally, I don't care for it. There are a great many things that they do BD> right, but there are a few things that are glaringly wrong. For example, BD> when looking thru the code it appears that they never NEVER lock session BD> variables. Ick. And there were a few other inconsistencies that I can't BD> remember off the top of my head. :-) I just remember that there was some BD> really wierd stuff about their code. BD> At one point, I needed some very basic forum stuff, but needed to use a BD> specific interface (I'm working with designers) and needed to allow access BD> to forums based on a single login (instead of a password for each forum) so BD> I ended up writing my own from scratch. It turned out to be /much/ easier BD> than editing theirs. BD> I guess this would be an OK base if they let it go open-source. It's got a BD> lot of nice features. But the fact that you have to edit the code to make BD> it run properly doesn't make it a 'good' product in my mind. BD> --Ben Doom BD> Programmer & General Lackey BD> Moonbow Software BD> : -----Original Message----- BD> : From: Jason Miller [mailto:[EMAIL PROTECTED]] BD> : Sent: Thursday, December 26, 2002 8:40 PM BD> : To: CF-Talk BD> : Subject: Re: FW: Cold Fusion forum (OPEN SOURCE?) BD> : BD> : BD> : Out of the whole - annoying forum search - price vs usability vs BD> : scalability vs features blah blah - I found these guys - Code 2 go.. I BD> : never purchased but it seemed the best price and the most feature rich. BD> : And open source I beleive was under $300. To me that seems quite BD> : affordable to start up some forums. BD> : BD> : http://www.cfcode.com/ <http://www.cfcode.com/> BD> : BD> : worth a look. BD> : jay miller BD> : BD> : Jim Davis wrote: BD> : BD> : BD> : I'd be happy to throw my BBML Parser into the mix: BD> : BD> : BD> : BD> : http://www.depressedpress.com/DepressedPress/Content/ColdFusio BD> : <http://www.depressedpress.com/DepressedPress/Content/ColdFusio> BD> : BD> : n/CustomTags/DP_ParseBBML/Index.cfm BD> : BD> : BD> : BD> : I keep meaning to build a "real" forum system but I only seem BD> : BD> : to get the time to throw together components of one... ;^) BD> : BD> : I'd be happy to participate in a community forum project. BD> : BD> : BD> : BD> : Jim Davis BD> : BD> : BD> : BD> : BD> : BD> : -----Original Message----- BD> : BD> : From: Tony Schreiber [ mailto:[EMAIL PROTECTED] BD> : <mailto:[EMAIL PROTECTED]> ] BD> : BD> : Sent: Thursday, December 26, 2002 10:37 AM BD> : BD> : To: CF-Talk BD> : BD> : Subject: RE: Cold Fusion forum (OPEN SOURCE?) BD> : BD> : BD> : BD> : BD> : BD> : I'd be willing to open SMB to other developers... BD> : BD> : BD> : BD> : http://www.simplemessageboard.com/ <http://www.simplemessageboard.com/> BD> : BD> : BD> : BD> : BD> : BD> : BD> : BD> : BD> : BD> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
