In my experience, GC collected by the gbak is different from sweep.
I also have a problem with only my big customer (35Gb database) when the
system become slow and slow over time. The solution was do a gbak with
Garbage collect and then a sweep after.
First time you do this it will take probably a couple of hours. Sweep
moves the transaction counter, gbak no (at least no in every situation).
For testing purpose you can run a sweep now and the backup will take a
lot less time this night. Give a try.
On 05/05/2015 08:12, Nick Upson [email protected] [firebird-support] wrote:
On 5 May 2015 at 12:09, Fabiano Kureck - Desenvolvimento SCI
[email protected] <mailto:[email protected]> [firebird-support]
<[email protected]
<mailto:[email protected]>> wrote:
Did you run a Sweep before backup?
no but then the backup does gc, I'm interested in why the suggestion,
I can try it
Nick Upson, Telensa Ltd, Senior Operations Network Engineer
direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
