Subject Re: [firebird-support] Re: Update big table and nbackup benefit or not?
Author liviuslivius

Karol,

if you worry about database size after update, i could suggest to split huge update
by few smaller, each in own transaction and garbage collect between passes.
I.e. something like

update t set ... where id between 0 and N;
commit;
select count(*) from t where id between 0 and N;
commit;

update t set ... where id between N+1 and 2*N;
commit;
select count(*) from t where id between N+1 and 2*N;
commit;
...

Regards,
Vlad
._,___
Hi,
 
good concept -split updates and collect unused pages.
I will try.
 
thanks Vlad
 
regards,
Karol Bieniaszewski