On Thursday, March 21, 2002, at 01:05 PM, Dave Rolsky wrote: >> Further on, he was discussing threaded discussion forums and assumed a >> recursive query. While recursing the DATA is probably (though >> provabably not >> always) necessary, there is no need to storm the db with that many >> queries, >> since query setup time, queing, and results extraction have noticable >> time >> penalties. Extracting the data with a single query and recursing it in >> RAM is >> a much more db and cpu friendly idea. > > This I can agree on, though it is more a limitation of SQL, which > provides > no meaningful way to do a recursive query.
Vanilla SQL, perhaps, but not Oracle's flavor! CONNECT BY PRIOR :-) -- -- Tom Mornini -- eWingz Systems, Inc. -- -- ICQ: 113526784, AOL: tmornini, Yahoo: tmornini, MSN: tmornini