performance of sql tree models

[Anonymous]

I can't really answer your first question since I've never used either implementation much (though your own analysis seems accurate), but concerning your second question, you should take a look at the Transactional and Locking Statements in the MySQL documentation.