Stories
Slash Boxes
Comments
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

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • by brev (1827) on 2003.04.09 4:52 (#18928)

    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.