Subject | FB1.0 Problem with updates ? Database-file keeps on growing without adding reco |
---|---|
Author | luc_decaluwe <luc.decaluwe@aucxistrading |
Post date | 2002-12-10T09:12:44Z |
Hello,
I need some help.
I would like to update 250 records each minute but I noticed that the
physical file keeps on growing.
I've tried to limit this by setting the sweep interval to 1 instead
of the
default 20000 but without any effect. I've checked if my
transactions were
committed, this was allright. The system has to run continuously
without
any down-time. I've got one stored procedure that updates the
table. If I
try to backup the database, it takes more then 2 hours for a file of
80 MB.
Why does the file keeps on growing just using updates, not adding
records ?
Thanks
I need some help.
I would like to update 250 records each minute but I noticed that the
physical file keeps on growing.
I've tried to limit this by setting the sweep interval to 1 instead
of the
default 20000 but without any effect. I've checked if my
transactions were
committed, this was allright. The system has to run continuously
without
any down-time. I've got one stored procedure that updates the
table. If I
try to backup the database, it takes more then 2 hours for a file of
80 MB.
Why does the file keeps on growing just using updates, not adding
records ?
Thanks