On 5 May 2015 at 12:23, Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support] <firebird-support@yahoogroups.com> 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