RE: nested sets vs. key path method

ll [mailto:[EMAIL PROTECTED]] Sent: 13 February 2001 11:13 To: [EMAIL PROTECTED] Subject: Re: nested sets vs. key path method >Hello, >at the time I try to figure out what's the best way >to get a kind of parent/child - hierarchy with unlimited >subchild. >My special attention is

Re: nested sets vs. key path method

>Hello, >at the time I try to figure out what's the best way >to get a kind of parent/child - hierarchy with unlimited >subchild. >My special attention is situated on really fast SELECT statements. > >Actually I'm using nested sets like: > >CREATE TABLE Personnel >(emp CHAR(10) PRIMARY KEY, >salar

nested sets vs. key path method

Hello, at the time I try to figure out what's the best way to get a kind of parent/child - hierarchy with unlimited subchild. My special attention is situated on really fast SELECT statements. Actually I'm using nested sets like: CREATE TABLE Personnel (emp CHAR(10) PRIMARY KEY, sala