|
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
Navigation:
[Reply to this message]
|