Re: "Clean" SQL (Avoid multiple reference to a table)
Re: "Clean" SQL (Avoid multiple reference to a table)
- Subject: Re: "Clean" SQL (Avoid multiple reference to a table)
- From: Art Isbell <email@hidden>
- Date: Fri, 4 May 2007 15:26:52 -1000
On May 4, 2007, at 3:15 PM, John Kuczynski wrote:
Is there any way to influence EOF to generate better SQL (i.e. no
repetition of a Table name when doing a many-many join)?
Are there any 3rd party libraries that fix what's described below?)
Before spending too much time worrying about this, ask your DB to
show the execution plans for the SQL generated by EOF and manually by
you. If the execution plan for the EOF-generated SQL is less
efficient than that of the manually-written SQL, then you have a
reason to modify EOF to generate "better" SQL. SQL query optimizers
are generally pretty good, so EOF's SQL might be no less efficient
than hand-tuned SQL.
EOF provides hooks that allow one to control the SQL that's
generated if you need to do so.
Aloha,
Art
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden