Re: [firebird-support] Re: Update big table and nbackup benefit or not?
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
[firebird-support] Re: Update big table and nbackup benefit or not?
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