Re: EOF, MySQL and DELETE CASCADE
Re: EOF, MySQL and DELETE CASCADE
- Subject: Re: EOF, MySQL and DELETE CASCADE
- From: Anjo Krank <email@hidden>
- Date: Tue, 24 Feb 2009 14:42:04 +0100
EOF doesn't care about DB delete rules anyway? I'd be rather amazed if
there is a plugin that has the power to handle this differently. After
all, what would happen about your willDelete() methods...
Cheers, Anjo
Am 24.02.2009 um 14:27 schrieb Pascal Robert:
Hi list,
Can somebody confirm that the MySQL plugin don't care about DELETE
CASCADE rules on a FK in MySQL (4.1)? I switched a small db to
InnoDB and added FK with the DELETE CASCADE option, but EOF still
fetch the parent objects (SELECT * FROM parent), all childs (SELECT
* FROM child) and will issue a DELETE statement for each child...
which is not efficient at all.
-------------------------------------------------------
Pascal Robert
http://www.macti.ca
http://www.aircourriel.com
http://www.linkedin.com/in/macti
Skype: MacTICanada
AIM/iChat : MacTICanada
_______________________________________________
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
_______________________________________________
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