Best way to manage your pages

[eluser]m4rw3r[/eluser]
The adjacency list model can be slow, if you for example want to fetch a node deep in the tree or if you want to fetch the parents of a node, so I recommend using the Nested Sets approach: http://www.sitepoint.com/article/hierarc...database/2

discussion thread on forum and Thunder UK's model: http://ellislab.com/forums/viewthread/47671/
or my model: http://ellislab.com/forums/viewthread/74114/