laziness, impatience, and hubris | |
PerlMonks |
Re^5: message board thread quandaryby clinton (Priest) |
on Sep 02, 2007 at 15:48 UTC ( [id://636614]=note: print w/replies, xml ) | Need Help?? |
Good point :)
However, by selecting all the descendants at once, you do have all the information to build a tree within your program. I'm guessing here, but I would think that doing it in memory would still be faster than doing it with multiple selects. I would concede to those with more experience though :) Clint Update I'm assuming that by selecting all of the objects, you are also receiving the parent_id of each object, which would give you the information to build the tree.
In Section
Seekers of Perl Wisdom
|
|