Recursiv/hierarchical query?

[Ruslan Zasukhin]

On 1/21/09 11:26 PM, "Bart Pietercil" <bart.pietercil at cognosis.be> wrote:

> continuing the discussion here
> 
> so are you saying that for the moment there is NO SAVE way to traverse
> a hierarchy in Valentina SQL ?

IF you don't know how much deep will be recursion

Of course in most case-sensitive  I think you will know that it is few
levels only.

For example, parents of people. How much we can know our parents? 3-5 levels
up?

Even if deep is 1000 I think we okay.

But if you have table 10 millions and recursion in 10 millions must be
tested how much RAM eaten


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]