our datamodel is a tree which consists of x layers and any number of nodes such as:
o / \ o o / \ \ o o o / \ \ x x ...
Sometimes we need to update / restructure the whole tree. This operation is quite heavy if we have like 40000 nodes. Performing just the queries takes up to 2 minutes (which is still acceptable for 40000 nodes ? - I don’t know) but what is even more strange is that the commit itself takes 50(!!!) minutes to finish. This is just unacceptable for productive usage. Why is that so slow? What can we do to improve the performance?
And what is even worse is that during that time no read operation is possible, the database seems just blocked at all.
Let me know if you need more infos.