On May 30, 2008, at 3:35 PM, Alan Ward wrote:
OK, so it sounds like the update is fine but how many SQL statements
occur when you try to insert a new Person?
Should be the same, flattened or not flattened:
1. Fetch the Person
2. Fetch the PK for each company to create an array of company faults*
3. Fetch the new PK
4. Write the new Person
5. Write the new join table row
* it would be good if this could be eliminated
Pierre? Hello? Feeling up to a challenge? :-P
Chuck
On May 30, 2008, at 4:28 PM, Mike Schrag wrote:
No, I meant an insert or update that didn't modify the
relationship. It sounds like your test shows my recollection to
be wrong
with recent WO versions. I'm pretty sure it was true at some
point in the past though.
Hang on a minute.... what was flattened in your model?
Company
id
name
>> people (flattened)
Person
id
name
>> companies (flattened)
(CompanyPerson)
companyID
personID
ms
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/award%40apple.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
This email sent to [EMAIL PROTECTED]
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
