On 12/20/2011 6:42 PM, Poul Dige wrote:
>
> How large is your DB?
>
> And just a thought: is auto sweep enabled on your database? I mean:
> could it by accident run an automatic sweep already when you start
> your own?
>
> Kind regards
> Poul
>
>
> Fra: firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> [mailto:firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>] På vegne af Vander Clock
> Stephane
> Sendt: 20. december 2011 08:22
> Til: firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> Emne: [firebird-support] backup very slow and how often sweep a
> database ?
>
>
>
> Hello,
>
> Everyday i sweep the database and i backup it
>
> gfix.exe -sweep
>
> and just after a backup like this :
>
> gbak.exe -B -t -v -z
>
> the probleme is that the sweep can take up to 5 hours to finish and the
> backup up to 12 hours to finish :(
> i know that in the backup i don't put the -g params (inhibit garbage
> collection) but someone say me that
> the -g do something else that the gfix.exe -sweep doesn't do ...
>
> now i need to know, how often i need to launch the gfix.exe -sweep and
> the gbak.exe -B without the -g params ? everydays seam not anymore
> possible because of the time taken
> by these process...
>
> one time a month ?
>
> thanks by advance for you help
> stéphane
>
>
> [Non-text portions of this message have been removed]
>
>


[Non-text portions of this message have been removed]