Nested set model: Difference between revisions

Revision as of 09:36, 28 August 2019

Revision as of 02:07, 16 September 2019

Line 54:

==Performance==

Queries using nested sets can be expected to be faster than queries using a [[stored procedure]] to traverse an adjacency list, and so are the faster option for databases which lack native recursive query constructs, such as [[MySQL]].<ref>{{Citation

| title= Adjacency list vs. nested sets: MySQL

| author= Quassnoi