At 09:07 AM 9/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 ?

Wrong.
A gap that grows larger and larger throughout the day is not a problem that
a sweep will fix.

>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 ?

It would not help your problem. You need to find why the gap is getting
unreasonably large, and repair your software and/or provide some training
for users about abandoning their workstations with unfinished
work..probably both are pertinent to your problem.

>If the sweep function kicks in, and no user is connected, will the
>gab then be somewhere between 0 and 1 ?

No, the gap won't change until the "interesting" transaction is
resolved. If your software doesn't take care of it then nothing will,
except a server shutdown. Meanwhile, you have an ever-accumulating pile of
old record versions which won't be touched by housekeeping.

heLen