How would you implement a threaded forum?
timmaah: http://threebit.net/tutorials/nestedset/tutorial1.htmlUsing 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.