Re:Why we're ending support for MySQL
by dragonwriter on Wednesday July 03, 2019 @12:42PM
(#20346003)
> All they had to do was implement a nested set pattern for their groups
Nested set is not at all performant. It has much worse read and worse write performance (also, takes more storage space) than adjacency list with in-DB recursive queries.
Nested set is not at all performant. It has much worse read and worse write performance (also, takes more storage space) than adjacency list with in-DB recursive queries.