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

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

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