Re: Creating a Hierarchical Structure

One technique for reducing the number of inserts is to have a hierarchy for roles of people, not people themselves.
One of the columns in this hierarchy table is Person_Id which is a foreign key. When a person leaves a role, the Person_ID is set to null, indicating the role is vacant. When a new person is named to the role, Person_ID is updated again.

The other columns of the hierarchy table follow the nested set concept.

Now, the only time we have to re do the nested sets themselves is when a new role is created. This is presumably less often than the reassignment of persons.

--
Regards,
    David Cressey
    www.dcressey.com
"watf22" <watf22_at_yahoo.com> wrote in message
news:a12de98f.0109050920.6f1668d8_at_posting.google.com...