| 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