[thelist] [DB Design] Recursive Directory Structure

[rudy]

> Caching makes sense if your structure changes rarely.

indeed, and that's a good point, mike

then the poor performance hit doesn't hurt

when you traverse the tree and pull out the nodes, make sure you save some
type of "level" indicator (to be used, for example, to set the amount of
indentation when printing the nodes in a nested fashion), as well as,
perhaps, some kind of sort key (although an array index fulfills this role
nicely)

rudy