Modified Preorder Tree Traversal (MPTT)

published on April 4th, 2008 · more from the blog →

Just stumbled upon this method of storing hierarchal data in a flat database and all I can say is its bloomin genius, it will change my life forever; no more crappy inefficient recursive functions.. I could explain it... but why bother when there's a great post accessible here.. you might find it hard to get your head around it at first, but trust me, you'll see the light.

MPTT