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 (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net > > This email sent to ch...@global-village.net -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
