update-objects-joins help

Hi. Lispworks 4.3.6, Windows 2000. Given a db schema something like this:

(def-view-class hobbit ((key2 ...) (other joins ...)))
(def-view-class fellowship-members ((key1 ...) (joins with HOBBIT via key2
....)))
(def-view-class fellowship ((key1 ...) (joins with FELLOWSHIP-MEMBERS via
key1 ...)))

If I query the FELLOWSHIP table and invoke UPDATE-OBJECTS-JOINS on the
result, will the optimization cascade through to the joins initiated by
classes FELLOWSHIP-MEMBERS and HOBBIT, or is it a single level only? For
example:

(let ((result (sql:select 'fellowship ...)))
  (sql:update-objects-joins result :slots t :max-len 1000))

We have some complex table relationships and I'm trying to wring as much
performance out of our queries as possible. If UOJ is single-level only, can
I coerce it to yield multi-level behavior? Thanks...

David E. Young
Bloodhound Software, Inc.
http://bloodhoundinc.com

"For wisdom is more precious than rubies,
and nothing you desire can compare with her."
  -- Prov. 8:11

"But all the world understands my language."
  -- Franz Joseph Haydn (1732-1809)


This email message is for the sole use of the intended recipients(s) and may contain confidential and privileged information of Bloodhound Software, Inc.. Any unauthorized review, use, disclosure is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.