[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Long time to delete a record?

  • Thread starter Thread starter PatrickOReilly
  • Start date Start date
Status
Not open for further replies.
P

PatrickOReilly

Guest
Blake, that looks like Dynamics code and table names. Yes? Dynamics implemented a number of cascading deletes, or else delete validations to prevent orphan data, in DB triggers. Sometimes the foreign keys on the related tables are not indexed (!!!), and that results in these very slow deletes. Go have a look at the delete trigger's code for the user_ctl table. Hope that heps...

Continue reading...
 
Status
Not open for further replies.
Back
Top