| Subject | Re: [firebird-support] large system slows over time |
|---|---|
| Author | Fabiano Kureck - Desenvolvimento SCI |
| Post date | 2015-05-05T11:23:27Z |
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 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
nu@telensa.com [firebird-support] wrote:
On 5 May 2015 at 12:09, Fabiano Kureck - Desenvolvimento SCI fabiano@sci10.com.br [firebird-support] <firebird-support@yahoogroups.com> 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