Dov, You're welcome to download the beta and see for yourself =) That's the joy of open source software.
I can say that nobody has brought forth any performance issues, and I don't tend to spend a lot of time tackling theoretical problems that nobody is having. CFMBB is a young application. Of course, it's based on Ray's Galleon with a whole slew of additions. Galleon cached user information for for all users, for the purpose of displaying things like ranks, location, etc.. in the postings. I haven't really changed that. Versions of CFMBB prior to 1.20 would retrieve user information for the user executing the request (if logged in) for every request. Version 1.20 caches the authenticated user information in session and only queries the database if the session has expired, or when it knows it needs to update the user information in session (ie, when you've updated your profile, toggled subscription information, etc). This reduces a lot of the database hits. (It's worth noting that Galleon didn't do this, so I degraded the performance a bit in previous versions of CFMBB) Specifically to answer your questions: > I.e- are queries/stats/content cached via things like CF_Accelerate, or > CF_mod_cachetagoutput? No. Never heard of those things, never had a need for them. > Are posts indexed for search performance? Probably not. I haven't messed with the search functionality beyond what was originally in Galleon. > After spending alot of time examining the java-based MVNForum discussion board, I found > that certain de-normalization of data is great for performance. > > If I'm missing something, and this is addressed, please disregard the below message. If not, > please consider adding the following de-normalization optimizations to the database. > > Based on that, and a brief review of this code, I recommend the following: > > 1) ReplyCount on every thread > 2) TotalPostCount, TotalThreadCount on every member > 3) TotalUnreadCount on every member (private msgs) > 4) TotalThreadCount on every forum and conference > 5) TotalPostCount on every forum and conference #2 deals with rank information of course, and I think that's cached as part of the user information. #1 and #5 should be implemented - I'd done so in the original version of CFMBB years ago before I ended up moving to the Galleon codebase. But I haven't implemented it yet. #4 - The total thread count isn't used anywhere, so there's really no need to cache it. =) #3 - I don't think it's a good idea, I don't see how it would improve performance since it's only relevant when you're actually looking at your inbox.. and you wouldn't want to cache that because otherwise you wouldn't be able to notify users of new private messages when they arrive (a feature of PHPBB that I like) > These are the ones which come to mind immediately. Having built a forum app which > currently has nearly 400,000 posts in 120,000 threads, these optimizations were very > well received. > > Also, if content is being searched, perhaps it should be indexed. MVNForum does it > via lucene, and it's a great way to let the DB do what it does best, which isn't always > full text searching... That would be something for users to implement themselves, because not all providers offer access to Verity / Lucene. > In my version, I also cache the most recent post per forum, to show them on the main > pages, and cache things like forum lists, member lists, etc... Caching the forum list along with the last post might not be a bad idea. I wouldn't waste my time caching the member list because even in a large, active forum, people aren't looking at the member list that often. Rick -- I'm not certified, but I have been told that I'm certifiable... Visit http://www.opensourcecf.com today! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271565 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
