How much does it extend by, can you give a good a bad DB stats.

I would be amazed if during the course that the differences could cause you
a problem. More likely some business process e.g. No users, activity
generally or specific poorly written queries (as far as the server is
concerned).

Do you audit all activity against the server?


Jason Chapman
JAC2 Consultancy

Training - Development - Consultancy
Delphi, InterBase, Firebird, OOAD, Development lifecycle assistance,
Troubleshooting projects, QA.....
www: When I get round to it....
Mob: (+44) 07966 211 959 (preferred)
Tel: (+44) 01928 751088

"Svein Erling Tysvaer" <svein.erling.tysvaer@...> wrote in
message news:5.1.0.14.0.20030109104327.01f0e090@[158.36.132.22]...

> 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
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>