Yes true. DB are a rational, rather than hierarchical data. LDAP is a closer match, and of course the file system is another. The problem with moving it to XML/other is that you can't do joins on the data.
Many DB's have extensions to help with trees. It will be interesting to see what Microsoft will do in this area, as SQL server engine is going to be used to implement the new MS File system. WB > It seems though, if you are need that much nested data there is probably a > better solution to the problem then this type of tree model (i.e. using > master - detail tables) that a database might be more optimized for (or > perhaps xml might be a solution). > > Rob > > > The problems with that method is path enumeratation etc. > It's easy if you have an id and just want the category under x, > > But what if you want the nodes from root to a deeply nested node. It turns > out to be a very expensive query... > Thats why the Nested Tree Model is useful (see my last mail) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4