Re: Joins with WebObjects
Re: Joins with WebObjects
- Subject: Re: Joins with WebObjects
- From: email@hidden
- Date: Sat, 19 Mar 2005 17:42:27 +0100
hi Guido,
it could be a jdbc driver problem or something.
I use MS-SQL server and EOF uses the same technique for joins. i mean t0.nr
= t1.nr etc...
i don't believe this is the problem.
this is an sql statement and both are similar.
try to ask in this sql forum about the differences, if you still believe
there the statements are not the same.
http://www.sqlteam.com/forums/forum.asp?FORUM_ID=4
let me know what you find out :)
peaSe,
Sako.
----- Original Message -----
From: "Guido Neitzer" <email@hidden>
To: "WebObjects Dev" <email@hidden>; "WebObjects Dev
(Apple)" <email@hidden>
Sent: Saturday, March 19, 2005 5:37 PM
Subject: Re: Joins with WebObjects
> "Geoff Hopson" <email@hidden> wrote:
>
> > Well, the only difference between the two outputs you supply is the
> > 'SVI_JOINS' part. IN the fast one, you look like you are joining OK on
> > the DGA_DIENSTLEISTER_ZU_FACHRICHTUNG table (Which I think is your n:m
> > table) on column id2, whereas on the slow on you have a SVI_JOINS on
> > "DGA_DIENSTLEISTER" table, which is one of the ends of the many-to-many.
> > So, something wrong there.
>
> Yes, I have seen this - but I don't know what it means ... ;-) Sorry, no
> database expert, but getting better.
>
> > It looks like maybe your eomodel may be incorrectly defined? Please
> > check you have set the many to many up correctly.
>
> I have triple checked this and don't think that there is something wrong.
If
> I try the same model and the same data with PostgreSQL the performance is
> good (could only test on my Powerbook, so no direct comparison).
>
> cug
>
>
> _______________________________________________
> WebObjects-dev mailing list
> email@hidden
> http://www.omnigroup.com/mailman/listinfo/webobjects-dev
>
>
_______________________________________________
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