Re: Joins with WebObjects
Re: Joins with WebObjects
- Subject: Re: Joins with WebObjects
- From: Guido Neitzer <email@hidden>
- Date: Sat, 19 Mar 2005 17:37:51 +0100
"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
_______________________________________________
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