Louis Werth wrote:

> Hi
>
> I recently began with a database cleanup procedure, I deleted about 4Gig of
> data out of a 9gig database.
>
> Before the script, it took about 1hour to backup database and 1.5hours to
> restore.
>
> Cleanup Script takes about 14min to complete.
>
> Backup after script takes 12hours to backup and 1.5 to restore.
>
> What can I do to speed this up? I cannot afford that my client go down for
> 13Hours +
>
> Any help would be appreciated.
>
> Software:
> =======
> WinXP Pro
> Firebird 1.53(Superserver)
> Database Page Size=8192
> Sweep Interval = 0
>
> Hardware:
> =======
> 2 Gig Ram
> 2x 160Gig Serial ATA2 HDD
> 3GHz Core 2 Duo Intel Processor.
>
>
> Regards
> Louis
>
>

Louis,

The first back-up that you run after the "clean-up" was slower beacuase
of the garbage collection process that was given to the back-up process.

Teh back-up visit every row on the table, so it encounters the removed
data and need to perform the clean-up. The next back-ups should be quicker.

By the way, why do your client need to be down during the back-up
process ???

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br