+1, Related reading (all from Bill Karwin of SQL Antipatterns fame):

http://stackoverflow.com/questions/192220/what-is-the-most-e...

http://www.slideshare.net/billkarwin/models-for-hierarchical...

http://karwin.blogspot.in/2010/03/rendering-trees-with-closu...