Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Delete on cascade question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Delete on cascade question

Subject: Delete on cascade question
From: Miguel Arroz <email@hidden>
Date: Mon, 27 Nov 2006 17:40:59 +0000

Hi!

I have a complicated graph of objects I want to delete. Basically almost all of them deletes the next ones on cascade. So, imagine A. A has a lot of Bs. Each B has a lot of Cs. Each C has a lot of Ds, and so on. On a moderate size example, I'm talking about 5000 objects or more.

Even if I choose the delete on cascade option in EOModeler, the generated SQL will not have the DELETE CASCADE code, so I guess it's all done by WO. And that means... it's terribly slow. So here's my two questions:

  1) Is there a way to make EOModeler generate the DELETE CASCADE SQL?

2) Adding it to the database definition (either EOModeler or manually) will conflict with EO in any way?

  Yours

Miguel Arroz

      "GUERRA E' PAZ
       LIBERDADE E' ESCRAVIDAO
       IGNORANCIA E' FORCA"       -- 1984

Miguel Arroz
http://www.ipragma.com

_______________________________________________
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


Follow-Ups:

Re: Delete on cascade question
From: Jacky Gagnon <email@hidden>
Re: Delete on cascade question
From: Chuck Hill <email@hidden>


Prev by Date:
Apache, mod-rewrite, and client IP

Next by Date:
Re: Delete on cascade question

Previous by thread:
Apache, mod-rewrite, and client IP

Next by thread:
Re: Delete on cascade question

Index(es):

Date
Thread