Subject Re: [firebird-support] Problem with backup
Author Nick Upson
In article <ctr100+is8l@...>, Marcoaureliocastro wrote:
> What happens when I delete a lot of records in a data base and try
> to make a backup of it? Let me explain: I have a table with 5 milion
> records and delete 2 milion records of it. The delete is ok, but the
> backup stays lock (it is realy not) when reaches to this table. The
> backup takes much more time to backup empty space than to backup
> real data. Why is it?

Depends upon your gbak args, sounds like it's doing a garbage collection
which is more work than just backing up the data

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly