Subject Re: [firebird-support] Performance of recursive table
Author Milan Babuskov
chrisacron wrote:
> In my application I use a self-related table to define complex
> classifications. The number of levels are theoretically unlimited but
> in reality will probably be 10-15 maximum.
> Is there another way of doing this?

Write a recursive stored procedure?

With recursive SP you are not limited and go to any depth (or whatever
is the limitation of stack space).

Milan Babuskov