Same key, outer join. Index on key. Respose time is fast, good.
Just curious - is there a limit, is it for ex.possible to have 10 or more
levels - anyone who has tried ? No reason to - but it can be good to hear
from You with experience from multileveljoins.

Thanks, L ars


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

Remedy lists the practical limit as 6 different layers due to the fact that
every level of join is essentially a query on each form in the join. I
don't know what criteria they used to define the 6 levels, but I'm sure it
would depend on the quantity of data that is being queried and your hardware
setup. Obviously more data, more of a performace hit-Fast system, better
performance, und so weiter...

I've never created anything over 4 levels as I've never needed to, but also
because of possible performance issues.

Maybe you could be the guinea pig?!

4.0 Admin Guide Vol 1, Pg 7-8 for the info.

David Kirkpatrick
System Analyst
Legacy Health System
Portland, OR USA
503.415.5826 (Voice)
503.415.5126 (FAX)
dkirkpat@lhs.org



-----Original Message-----
From: lars.pettersson@DATA.VATTENFALL.SE
[mailto:lars.pettersson@DATA.VATTENFALL.SE]
Sent: Thursday, January 13, 2000 2:41 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Levels of joins


Hi - I have created a joinform based on 2 other joins, 4 involved forms.
Same key, outer join. Index on key. Respose time is fast, good.
Just curious - is there a limit, is it for ex.possible to have 10 or more
levels - anyone who has tried ? No reason to - but it can be good to hear
from You with experience from multileveljoins.

Thanks, L ars


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist