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.

- is it possible to disable record versions for these two tables?
after table update firebird keep only real record no updated version.

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

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

ps. sorry my English.

Thanks.