4 ms·
And even better - knowing that quite a few database engines have extensions to help handling hierarchical data and it probably depends on the details as to whic
by arethuza 13y ago
And even better - knowing that quite a few database engines have extensions to help handling hierarchical data and it probably depends on the details as to which is actually better in a particular circumstance.
- nbouscal 13y agoDefinitely. Nested sets have a lot of weaknesses, and any decent modern database will have CTEs so you can just use an adjacency list with a recursive query, or materialize out the closure table.