At 09:07 09.01.2003 +0000, you wrote:

>Hi
>
>I have a customer who complains about the speed dropping during the
>day.
>
>In the morning the transaktions (oldest transaction, oldest active,
>etc) are alike.
>
>But during the day the gab extends.
>The sweep function takes care of this, as far as I know. Correct ?
>
>The default value for sweep is 20.000, correct ?
>
>Could I change that to i.e. 1.000 ?
>
>Would it affect the system in any way ?
>
>
>If the sweep function kicks in, and no user is connected, will the
>gab then be somewhere between 0 and 1 ?

Michael,
what you ought to do is to find out why the gap extends. There must be one
or more long running transactions and as a result Firebird has to keep old
versions of records. Note that the long running transaction does not
necessarily have to do updates. Fix this and your problem dissolves.

HTH,

Set

- I support Firebird, I am a FirebirdSQL Foundation member.
- Join today at http://www.FirebirdSQL.org/Foundation