BTW, I was inspired by your posting to do the following: forum listing is now cached in the application scope, and updated only when the data changes.. ie, new posts, new forums, deleted posts, etc...
Per forum message count and last post is now stored in the forums table, eliminating the need for a huge group by clause and two additional joins. Plus it's cached (see above) thread listing is now cached in the application scope, and updated only when the data changes.. ie, new posts, deleted posts, etc... per thread message count and last post time is now stored in the threads table, eliminating the need for a huge group by clause and one additional join, plus I removed a join to the users table which was unnecessary. Oh, and it's cached. I've got a few more bugs to work on, and I need to do a few more test installations... I'm hoping to have a release ready by the end of the week! Rick -- I'm not certified, but I have been told that I'm certifiable... Visit http://www.opensourcecf.com today! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271662 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
