Subject Re: [firebird-support] Re: One table taking a long time to insert/update
Author Douglas Tosi
On Wed, Jun 25, 2008 at 9:23 PM, robertgilland
<robert.gilland@...> wrote:
> Variable header data:
> Sweep interval: 0
> TABLE1 (130)
> Average version length: 9.00, total versions: 202075, max versions: 3

You have automatic sweep disabled in your database. Do you run gfix
-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.

Douglas Tosi