> How does cf_maketree do its thing? I've never used it.
using list and struct functions with a lot of looping. major pain in
the neck code.
>
> 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.
>
I think the nested set model would still work great in a threaded
message board. Because you'd have multiple trees in the table. each
tree would be assigned to a thread so you'd only be updating a small
number of records at a time. The db is pretty efficient with these
types of updates, it's not as if you are looping over a bunch of update
statements.
Anyway, ya, this model is denormalized, but man is it ever cool!
Steve
> --
> 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
