Re: EOF, MySQL and DELETE CASCADE
Re: EOF, MySQL and DELETE CASCADE
- Subject: Re: EOF, MySQL and DELETE CASCADE
- From: Pascal Robert <email@hidden>
- Date: Tue, 24 Feb 2009 08:54:25 -0500
So EOF will issue a DELETE statement for each child no matter which
RDBMS is used? I think I will switch to plain SQL :-/
Technique for mass insertions and deletion should be a good topic for
WOWODC West :-)
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.
_______________________________________________
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