Forum OpenACS Development: Re: Need some help with tree_sortkey

Collapse
5: Re: Need some help with tree_sortkey (response to 4)
Posted by Tom Jackson on 02/07/04 04:34 AM

Wow, sorry for the delay, we were without power for about four hours! Lightning struck. My laptop and routers, etc. were fine, but I guess the cable company ran out of power.

Anyway, I guess one purpose of tree-sortkey is to provide order and hierarchy in a single table design. It is expensive to maintain, but then, hopefully the more numerous selects will be very fast.

Collapse
6: Re: Need some help with tree_sortkey (response to 5)
Posted by Mark Aufflick on 02/08/04 04:30 AM
But surely you can't guarantee that context_id provides that info in general - an object's context doesn't have to be it's parent - or did we agree to standardise on that?
Collapse
7: Re: Need some help with tree_sortkey (response to 6)
Posted by Tom Jackson on 02/08/04 05:01 AM

The only question I was trying to answer was how to use the tree_sortkey in the acs_objects table. I'm not guaranteeing anything.