Subject Re: [ib-support] FB1.0 Problem with updates ? Database-file keeps on growing without adding reco
Author Zdeno Jasek
Hello, luc_decaluwe,

Interbase has a multigeneration architecture - it means, there is no
difference between update and insert (old data are NOT deleted).

But you are right - 2 hours for a 80 MB file is very long time (sorry, I have not


> 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

> To unsubscribe from this group, send an email to:

> Your use of Yahoo! Groups is subject to theYahoo! Terms of Service.