nested sets are not generally faster. for anything which is not "get all direct and indirect children", they are slower than common table expressions (recursive

nested sets are not generally faster. for anything which is not "get all direct and indirect children", they are slower than common table expressions (recursive queries). in databases supporting cte's, that is.