a thoughtful web.
Good ideas and conversation. No ads, no tracking.   Login or Take a Tour!
comment
bhrgunatha  ·  3131 days ago  ·  link  ·    ·  parent  ·  post: Devski Update: Closure Tables

I've always cheated and designed tables that hold tree like data to include a level number and the parent in the table itself rather than a separate table. You can cheat and take a sneaky look at the data without joins! Take that Codd!

It adds some space overhead but makes querying so much easier.

And gives easy indexing options to increase performance.