> > > Thanks that will be helpful, I liked the idea of paths also. However if > you have 200,000 + nodes in a tree the paths might be coming hard to work > with. > > Yes, my tree was somewhat smaller! It seems to me that "with recursive" is the easiest method to manage this, although of course the DAL does not have any support for this.
I have been thinking more about the path method and for most cases can see that this would be a very high performance and easy method. Having read through several papers on tree structures which seem absurdly complex, I am amazed that the path method is not everyone's first choice for most simple tree structures. Even more so than the widely used nested sets. The paths are so intuitive and, not least, solve everyone's breadcrumb problems at a stroke! I wonder to myself why on earth everyone only seems to mention the path method as an after-thought. Best wishes David