Storing Hierarchical Data in a Database
I’m going to implement types/categories on sumbissions for Debianart.dk to classify them. I friend send me this great link on how to implement this and at the same time think of performance.
Take a look at this: Storing Hierarchical Data in a Database