I have left-right trees in my database which are a problem for performance. I'll switch to a system with a parentId and an orderId.
I'm looking for a sql script that can give me the index of a node in a left-right tree.
I have left-right trees in my database which are a problem for performance. I'll switch to a system with a parentId and an orderId.
I'm looking for a sql script that can give me the index of a node in a left-right tree.
Like this?