|Subject||Re: [firebird-support] Delete causes server to hang|
Hey TimThe code does not do anything active, but we run backup 4 times a day.
I have tried batching the delete, so that one batch runs in a autonomous transaction, and made at count on the table after each batch, but with no luck. The idea was to reduce the number of deleted rows that the garbage collector should process.
v_deletedcnt = 1000;
while (:v_deletedcnt = 1000) do
in autonomous transaction do
delete from requests where created < :delete_all_before rows 1000;
v_deletedcnt = row_count;
select count(*) from requests into :TEMP_CNT;