> We
> were using a modification of dinowitz's <cf_maketree> to reorder it,
> then we put the tree into an application variable which we queried off
> of using structfind() etc.
Steve,
How does cf_maketree do its thing? I've never used it.
Personally, I do all my tree building using ID/ParentID queries that are
managed on the CF side with the old "two structures, one flat, one threaded"
trick. So the only performance hit is in the recursive routine that actually
draws the tree, and most of that will go away (I suspect) with user-defined
functions in CF5. And if Allaire delivers a way to walk a structure
(StructNextParent(), for example), it'll be simple to do as well.
> Anyway, let me say this.... it was a MAJOR MAJOR pain in the ass, and it
> was slow as hell.
I can definitely see some advantages to nested sets in an application that
needs to constantly seek up and down the tree... say, to retrieve upstream
permissions settings or total downstream listing counts in a Yahoo-type
directory.
OTOH, it seems like a real pain in an environment like a threaded message
board, where inserts would be frequent, and the ability to move branches
around quickly would be very important.
--
Roger
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
