Subject Re: [firebird-support] Problems after many records deleted
Author Milan Babuskov
fabiano_bonin wrote:
> I had a table with 200.000 records.
> I deleted 180.000 records from this table.
>
> Now i'm trying to backup my database and the gbak stop in this table
> and never go away.
>
> Am i right? If yes, is there some workaround to avoid this delay?

If you don't have many records left in the table, you can copy them to
some temporary table (insert into .. select from), drop the original
table. Do backup/restore. Create the original table, copy data back, and
drop the temporary.

I sometimes do it like that.

--
Milan Babuskov
http://fbexport.sourceforge.net