Re: ToOneRelationship and saveChange method
Re: ToOneRelationship and saveChange method
- Subject: Re: ToOneRelationship and saveChange method
- From: Chuck Hill <email@hidden>
- Date: Tue, 20 Sep 2011 09:13:38 -0700
On 2011-09-19, at 11:56 PM, Jérémy DE ROYER [INGENCYS] wrote:
> Hi All,
>
> I have an editing context question.
>
> I've got 2 tables : contact and compaign
>
> I want to add contacts to a compaign so I've created a many to many relationship between the table contact and the table compaign. That work fine.
>
> Problem is that when I add (lots of) contacts to a compaign because webobjects, when updating database with saveChanges(), update all contacts in database
Does it UPDATE them, or just SELECT them?
> (even if fields of contacts haven't been changed).
>
> For table with 5 rows, I takes 20 secondes for 1000 added contacts, that's ok.
>
> But for table with more than 50 rows, I takes more than 2 minutes.
>
> What's the best solution to avoid that wast of time (that make problem when submitting form that takes to many time... for nothing)
>
> I though about :
> - creating "linking" table with no data row to avoid long save, but I have to change all my model...
> - remove contact from updatedObjects set, but that's dirty because willUpdate methods won't be called
>
> Any idea to avoir SQL update on objects that didn't changes except to Many Relationship ?
>
> Jérémy _______________________________________________
> 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
--
Chuck Hill Senior Consultant / VP Development
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden