I have faced the same situation on a number of occasions.
The approach that gave me the fastest development time is to create a view
that already does the joins. ND works very nicely with the approach and you
can use ND generated sql and the point click bindings. For a small number
of small tables this is the most efficient approach too.
In spite of the fact that joins are one of the most important operations
that relational databases do, they do them badly. They can quite often come
up with a bad plan that kills performance. If the tables are small and few
other tables are involved in the query, the join will be fine. If the
tables are large, or poorly indexed, or there are a lot of them, the joins
can kill your performance and go with the 3 queries.
Brendan Johnston
TeamND
-----Original Message-----
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 21, 1999 2:17 PM
To: [EMAIL PROTECTED]
Subject: [ND] manually binding Data fields
My question in a nutshell:
What's better...3 simpler DOs with point & click binding. vs. 1
complex DO with
manual binding?
Cracking it open:
I have a page that displays a Repeated. 3 columns in the repeated
have the same
domain. Therefore, the SQL for the Rpt requires joining to the same
table three
times. To pick the same table more than once in the FROM clause, I
believe I
have to use the SQL tab in the Properties dialog and override the
default SQL.
No problem, but then how can I bind the 3 columns to the
corresponding display
fields in the Repeated? i.e. how do I access the 3 columns via code
to use them
to do a setValue?
Maybe the better way is to create 3DOs (each one does one join to
the common
table) via point & click, and then bind their data field to the
corresponding
display field on the Rpt.
Advice from a performance perspective is also welcome.
Thanks!
Janet
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to:
http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
