| 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
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
