Subject Re: [firebird-support] large system slows over time
Author Nick Upson

On 5 May 2015 at 12:23, Fabiano Kureck - Desenvolvimento SCI fabiano@... [firebird-support] <> wrote:

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.

​I already do a sweep weekly, I also tried gbak -gc followed by a sweep the total time was even longer​

Nick Upson, Telensa Ltd, Senior Operations Network Engineer
direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200