Re: Best way of storing hierarchy data
Posted by: Peter Brawley
Date: May 30, 2021 05:46PM

See https://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html for a review of working with trees & other hierarchies in MySQL.

Common Table Expression support in MySQL 8.0 greatly improves MySQL query performance against edge list trees like the one you mention.

Options: ReplyQuote


Subject
Written By
Posted
Re: Best way of storing hierarchy data
May 30, 2021 05:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.