I'm designing an application that will require a whole series of heirarchies - its an action plan where the plans can be quite complex. The idea is a business event happens (a sale or a project is started ) and that triggers a whole set of events that must follow.
I'm thinking of using nested sets to lay out the heirarchies of events, because they are so flexible adn its so easy to move things about with them. But i'm a bit worried about how it might perform under load. I've used nested sets for ages in my CMS and had no problems at all. But you dont make hundreds of updates a day to a CMS node structure. Has anyone used an application using nested sets where there are lots of updates a day? Did it perform ok? My environment is Windows2003, CF7, MSSQLServer. We are provisioned ok for RAM and processor capacity, but dont want to clog it with too much activity from any one application. There are 400+ offices using this site - it's an extranet app. Can anyone give me any experience with nested sets and coldfusion/MSSQLServer with volumes of updates like that? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312739 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
