Mustafa S,ims,ek wrote:

> Hi,
>
> i have a firebird 1.5.5 database, ~2 GB and ~15 users, sweep interval : 20.000.
>
> after awhile my database getting slower. when i do backup-restore
> everything fine but about a month later again users getting slow
> response. my index and foreign key ok, i think. i update 2 tables a
> lot for stocks. after a month one table has 800.000+ updates and the
> other has 300.000+ updates. i think record versions and sweep cause
> this slowness.
>

First thing to do, show us the database statistics when the users note
the slowness, this will show us if you have a transaction management
problem.

> - is it possible to disable record versions for these two tables?
>

no

> after table update firebird keep only real record no updated version.
>

no, it keeps the versions interesting to other transactions visibility,
if your transaction management is good, it will keep only one version of
a record on most of the time.

> - upgrade from 1.5.5 to 2.1.2 could solve this record versions/sweep
> slowness problem?
>

You could see a little improvement because the way Garbage Collection
works in 2.X, but the solution for your problem could lie in another
place (my guess is long running transactions)

> - if i set the sweep interval to 0, could solve the problem?
>

Perhaps... It's better to set Sweep to 0, and schedule a manual sweep
(gfix) during off peak time.

> ps. sorry my English.
>
> Thanks.
>
>

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br