|Subject||Re: [firebird-support] large system slows over time|
On 5 May 2015 at 12:23, Fabiano Kureck - Desenvolvimento SCI fabiano@... [firebird-support] <email@example.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 longerNick Upson, Telensa Ltd, Senior Operations Network Engineerdirect +44 (0) 1799 533252, support hotline +44 (0) 1799 399200