ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
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.