Re: parent/child relationship in the same table.

In article <a6e74506.0111170946.26ce1190_at_posting.google.com>, James says...
>
>Here is the psuedo code:
>Call A(0)
>Function A(par)
> rs = db.execute("Select * from T_ParChild Where ParId = " & par)
> While (!rs.EOF)
> child = rs("Child")
> Print par, child, rs("Data")
> Call A(child)
> Loop
>End
>
>An oodb can perform the above much faster than relational dbs. In a
>relational db, the time to resolve the relationships increases with
>the number of records. In an oodb, the resolution time is not only
>quicker but constant regardless of number of "records".

Not quite. A relational database has a concept of "pipelining": it could answer the query above in a single pass through the table. Object folks thinking is frozen in terms of nested loops that user has to write. Received on Sat Nov 17 2001 - 21:25:48 CET