NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.
All the Perl that's Practical to Extract and Report
--Larry Wall
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.
tree traversal in SQL (Score:1)
Nobody has mentioned Oracle's CONNECT BY [oracle.com]. Hierarchical queries in one statement!
I doubt Ziggy is aware of this, but the tree hack you describe is roughly how ASPN [activestate.com] works. Ugly and inflexible, yes, but it gave us the performance we wanted, without having to shell out for Oracle.
It may have been a premature optimization. I personally was horrified by the idea during the design meetings. But it works very well in practice and it's easy to understand.
Reply to This