http://threebit.net/tutorials/nestedset/tutorial1.html http://threebit.net/tutorials/nestedset/tutorial1.html Using this method on a table with 1.2 million row

http://threebit.net/tutorials/nestedset/tutorial1.html http://threebit.net/tutorials/nestedset/tutorial1.html Using this method on a table with 1.2 million rows, I can get a thread with a single db call. It hasn't given me a single problem yet, though obviously it is slower then standard flat list.