Subject | Re: [firebird-support] Problems after many records deleted |
---|---|
Author | Milan Babuskov |
Post date | 2004-05-14T16:55:27Z |
fabiano_bonin wrote:
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
> I had a table with 200.000 records.If you don't have many records left in the table, you can copy them to
> 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?
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