3 ms·
An alternative is using a nested set https://en.m.wikipedia.org/wiki/Nested_set_model https://en.m.wikipedia.org/wiki/Nested_set_model
by camnora 7y ago
An alternative is using a nested set https://en.m.wikipedia.org/wiki/Nested_set_model https://en.m.wikipedia.org/wiki/Nested_set_model
- dekhn 7y ago"Updating requires renumbering and is therefore expensive".
- cryptonector 7y agoNo. Just use an RDBMS that doesn't suck -- one that supports WITH RECURSIVE CTEs.