[truncate]

Did you try using any MPTT libraries for your framework/rdbms? I've found that fairly simple to use. But of course performance should be better with NoSQL.