News for hackers. Stuff that matters.

A comment on Ask YC: what's the best way to model a threaded comment system like YC?.

Re:Ask YC: what's the best way to model a threaded comment s... by xirium on Sunday March 16, 2008 @01:13PM (#138257)
Have a message table and an ancestor table. The ancestor table allows you to find all ancestors of a message or all decendents of a message. This allows you to quickly retrieve a branch of the discussion tree.
[ Parent | on HN ]

There are no comments on this comment yet.