I posted a CFMBB performance-related question on the CFMBB forum http://www.cfmbb.org/messages.cfm?threadid=03900EE3-A75F-A0AD-057B05A656A94C3B
but got no responses. I'm widening up the audience, as I'm very curious how everyone is approaching performance for things like galleon or cfmbb. * Quoted from my post on cfmbb.org - feel free to respond here or there * Posted Tuesday, February 27, 2007 at 9:17 AM What measures exist in CFMBB to address performance? I.e- are queries/stats/content cached via things like CF_Accelerate, or CF_mod_cachetagoutput? Are posts indexed for search performance? 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 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... 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... Again, I'm not sure if these types of things are already happening this way in cfmbb, but I thought I'd share my thoughts just in case they would be useful.. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:271524 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
