Subject | Re: [firebird-support] Re: One table taking a long time to insert/update |
---|---|
Author | Douglas Tosi |
Post date | 2008-06-26T11:32:13Z |
On Wed, Jun 25, 2008 at 9:23 PM, robertgilland
<robert.gilland@...> wrote:
-sweep on a regular basis?
I´m not sure if it may cause of the slow insert you describe. But it´s
not good practice anyway.
The stuck transaction Sean Leyne mentioned may also me a big influence
on your problem.
[]s
Douglas Tosi
<robert.gilland@...> wrote:
> Variable header data:You have automatic sweep disabled in your database. Do you run gfix
> Sweep interval: 0
> TABLE1 (130)
> Average version length: 9.00, total versions: 202075, max versions: 3
-sweep on a regular basis?
I´m not sure if it may cause of the slow insert you describe. But it´s
not good practice anyway.
The stuck transaction Sean Leyne mentioned may also me a big influence
on your problem.
[]s
Douglas Tosi