Posted by Michael Fesser on 02/05/07 14:45

..oO(R. Rajesh Jeba Anbiah)

> Answer is Nested Set Model architecture <http://dev.mysql.com/
>tech-resources/articles/hierarchical-data.html>

Definitely not. In most cases a nested set structure is total overkill,
especially if all you need is a simple parent-child relation. Running
some queries recursively is quite cheap (even cheaper with prepared
statements) and also much simpler compared to the very complex issue of
handling a nested set.

Micha

[Back to original message]