Apple

Frank Stock

Op 19-apr-07, om 13:30 heeft Shravan Kumar.M het volgende geschreven:

Hello Frank,

When there is a one-to-many or many-to-many it is advised not use addObjectToBothSidesOfRelationshipWithKey instead use the individual addTo<relationShipName>() methods. When we use addObjectToBothSidesOfRelationshipWithKey , it tries to fault the objects in the relationship and that is what you see "Select statements". Better go with addTo<relationShipName>() methods in such cases.

Thanks & Rgds,
Shravan Kumar.M

"Let us learn from the past to profit by the present,and from the present to live better in the future."
--William WordsWorth
---------------------------------------------------------------

On 19-Apr-07, at 4:50 PM, email@hidden wrote:

From: Frank Stock <email@hidden>
Date: 19 April 2007 4:50:08 PM GMT+05:30
To: email@hidden
Subject: AddObjectToBothSidesOfRelationshipWithkey

Hi,

When I do this:

bpObject = new BlockProperty();
ec.insertObject(bpObject);
bpObject.setValue(value);
bpObject.addObjectToBothSidesOfRelationshipWithKey(bObject,"block");
bpObject.addObjectToBothSidesOfRelationshipWithKey(pObject,"property");

This will take 90 seconds to complete (will all the rest of the code)

I can see in the debugger that every time I do a AddObjectToBothSidesOfRelationshipWithkey WO will perform a select-statement,
the relations have a lot of records (>2000). I have to to that a lot of time and all I need is just to make a relation between the objects.
Why is WO performing a select every time and can I avoid that?
If I just do :
bpObject = new BlockProperty();
ec.insertObject(bpObject);
bpObject.setValue(value);
bObject.addToBlockProperty(bpObject);
pObject.addToBlockProperty(bpObject);

This will take 5 seconds to complete (will all the rest of the code)

Thanks,
Frank Stock
_______________________________________________
Webobjects-dev mailing list
email@hidden
http://lists.apple.com/mailman/listinfo/webobjects-dev

References:
	>Re: AddObjectToBothSidesOfRelationshipWithkey (From: "Shravan Kumar.M" <email@hidden>)