In addition to expensive insert/update, it is necessary to keep the left and right boundaries across ALL of your entries in perfect order. If the boundaries get out of whack, fixing the tree is a nightmare scenario.
I worked on a multi-tenant application with distinct trees present in one table and with one tree per table and so on. Fun fun fun!
I worked on a multi-tenant application with distinct trees present in one table and with one tree per table and so on. Fun fun fun!