Women in Technology

Hear us Roar



Article:
  Hierarchical SQL
Subject:   How about using integer type for path?
Date:   2004-08-19 05:21:31
From:   --CELKO--
Response to: How about using integer type for path?

I cover versions of that method in the book, too. It works fairly well for static situations in the real world. That is, if the tree does not get too deep or too wide.


You can also use a bigger gap than one in a nested sets model to speed up insertion by saving reorganization.