How fast is this comparing to nested sets? Some time ago I did my own nested sets implementation in Oracle and for 100k+ records the path from a leaf to root as

How fast is this comparing to nested sets? Some time ago I did my own nested sets implementation in Oracle and for 100k+ records the path from a leaf to root as well as all sub-tree nodes retrieval took seconds with WITH and milliseconds with nested sets (2-3 orders of magnitude faster).