Convert adjacency list model to a modified preorder tree traversal (MPTT) model hierarchy
This us more a note to self than anything else, as I trawled the internet trying to find a definitive answer to this. Modified preorder tree traversal (MPTT) is an efficient way to store and query hierarchical data in a database. This article on the MySQL site explains why this is the case with a neat comparison between [...]