|
Posted by Roman Ivanov on 11/18/05 22:32
blackwater dev wrote:
> I am sure others have encountered this so I am just looking for ideas.
>
> Say I have an ancestry application where the users can enter parents,
> children, etc. The children have children, etc.
>
> table people
> id
> parent_id
>
> what is the best way to pull this from the db minimizing the number of
> queries to build a tree view of parents to children?
This is complicated. How many people are you planning to have total? How
frequently will this info be updated?
Navigation:
[Reply to this message]
|