[thelist] [DB Design] Recursive Directory Structure
rudy
r937 at interlog.com
Sat Feb 1 20:11:01 CST 2003
> Is there some way to do this easily w/ Oracle?
yes, the syntax is something like CONNECT BY ... START WITH ...
you indicate which column is the recursive key, and the value to start with,
and then stand back, watch out for the poppencorken mit spitzensparken
(http://www.planetmvs.com/overhead/achtung.html)
i cannot comment on performance, because i have never had the opportunity to
play with this syntax
it is one call to the database, though, so it's just gotta be faster than
calling for one record at a time in a loop
no offence to all you object oriented coders, you might produce simple and
slick recursive functions, but calling for one record at a time is slow
rudy
More information about the thelist
mailing list