News for hackers. Stuff that matters.
Re:Fake Trees: Using Indents for Simpler UIs by barrkel on Saturday December 30, 2023 @02:13PM (#38818027)
I found using recursive CTEs incredibly slow for assembling tree data from a normalized representation. It would make getting the results of a query at least d times slower for assembling the path of nodes d deep in the hierarchy. The upside was cheap tree edit operations but those were a lot less frequent than reads.

There are no comments on this comment yet.