hello im implementing a portal and im choosing between the 'Nested Set' and
'Adjacency Lists tree' models.
<http://users.starpower.net/rjhalljr/Serve/MySQL/traer.html>


im perfectly aware of the 'Adjacency Lists tree' model how-to and I am
studying the 'Nested Set', example follows :

CREATE TABLE LanguageTree (

  Language VARCHAR(255) PRIMARY KEY
, Parent VARCHAR(255)
, Lft LONG
, Rgt LONG
, INDEX idxLft (Lft)
, INDEX idxRgt (Rgt)
) Comment = "Related languages";


            A[1 12]
          /          \
         /                \
    B[2 3]       C[4 11]
           /          \
          /            \
          D[5 8]     F[9 10]
             |
          E[6 7]


my doubt is that if i want to insert a new node, for example 'G' under 'A'

            A[1 12]
          /     |     \
         /               \
    B[2 3]    G[]   C[4 11]
           /             \
          /               \
          D[5 8]         F[9 10]
             |
          E[6 7]


i have? to update almost every left,righ fields after that node, resulting
in a website performance downgrade ....


help? even if thjats the only way, how can i do it? perhaps im getting it
wrong ...


best regards


Josť Moreira
TEGOPI S.A.
http://www.tegopi.pt









-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to