These are some good ideas. Those dang counts caused me all kinds of stress. I think I'll "innovate" these into Galleon. ;)
On 3/5/07, Rick Root <[EMAIL PROTECTED]> wrote: > 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! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271701 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
