Better than mine. The sort takes about 200ms for 110 items who's deepest item is 4 levels down.
At 06:54 PM 5/23/02, you wrote: >Testing here seems to show that the DB way is much, much faster - I'm >pulling 100 nested nodes in under 120 ms... > >-----Original Message----- >From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] >Sent: Thursday, May 23, 2002 3:52 PM >To: CF-Talk >Subject: RE: Build a tree of nodes/subnodes > > >At 06:48 PM 5/23/02, you wrote: >>I usually do a recursive custom tag to make my trees. I haven't tried >using >>UDFs for it because of database calls, but with CFMX, I'm sure it would be >The whole thing should only have a single DB call. Using a UDF on the >results of the DB call is all that's needed. Unless I'm missing something in >how your doing it. > >>nice. I haven't used the nested sets model before, but I have briefly >>looked at it. My problem with it seems that it's not normalized at all. >In >>that Intelligent Enterprise article, the lft and rgt columns seem like they >>could easily go out of wack if you're not careful. A single table with a >>recursive parent ID seems much logical. >> >>Sure, there are some more database calls, but it all depends on what you're >>trying to do. For example, we have an application with an advanced >>permissions system that involves cascading permissions and some other >>tidbits. When the user logs in, their permissions are pulled through >>recursive custom tags and set to the session scope. It's a one time thing >>for each login so any extra load is really not noticeable. >> >> >> >>Ben Johnson >>Hostworks, Inc. >> >> > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
