G
gus bjorklund
Guest
As peter says, you can use the stop after mechanism in this case. Depending on how your code was written, it is possible for each row (and its index entries) to be deleted in separate transactions. That would make it run comparatively slowly. Also, be careful what you wish for. If your code is deleting a million records in one transaction and the transaction timeout stops you at 999,000, all those deleted records have to be put back.
Continue reading...
Continue reading...