Radicore Forum: How To » Delete with Cascade

Home » RADICORE » How To » Delete with Cascade

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Delete with Cascade [message #2632]

Tue, 23 November 2010 08:30

gpatti
Messages: 283
Registered: August 2008

Senior Member

I have a couple of tables which have a master/detail relationship and delete integrity set to cascade. I've noticed that if I delete a master record (from a LIST screen) the delete operation can take a long time and even occasionally times out. Typically, there may be 200 - 250 detail rows related to the master row (so not huge numbers).

As far as I know my indexes are all set correctly. Is the performance possibly related to the frameowrk iterating each detail row and deleting it separately?

If so would a better solution be for me to remove the cascade option and manually delete the details rows on deletion of a master row in a single transaction?

Thanks,

Graham

Report message to a moderator

[Message index]

		Delete with Cascade By: gpatti on Tue, 23 November 2010 08:30
		Re: Delete with Cascade By: AJM on Wed, 24 November 2010 13:57

Previous Topic:	add another action button to enquire form
Next Topic:	grandparent - parent - child link entity

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Jul 09 19:13:03 EDT 2025

Total time taken to generate the page: 0.10357 seconds