The main advantage of the nested set model is that you don't have to use recursion or loops to get data out. Consequently it's very fast to recall stuff. Reorganizing the tree is more expensive than other storage mechanisms, but pulling stuff out is hella fast. By and large, you can get any piece of data out with a single query (possibly using a subquery as well).
cheers, barneyb On 1/30/06, Brad Wood <[EMAIL PROTECTED]> wrote: > 1. Recursion > or > 2. A while loop over a table variable > > ~Brad > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230848 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
