To help you, I need to know
the data types, the indexes in updated tables.
What the columns are get updated?
"Multi-version records" are freed when all transactions are done.

Alexander Knauer wrote:

> Hello,
>
> I use Firebird RC 2 on linux and in my database I have a table which
> gets updated in the following way:
>
> 1) every 24 hours this table is extended in a transaction by 2038
> records (2038 inserts in one transaction)
>
> 2) every 10 minutes 2038 records are updated in a transaction (the 2038
> records from te current day; 2038 updates in one transaction)
>
> the "problem" is that the database files increases EVERY day by
> approximately 7-8 MB. but the 2038 records which are inserted every 24
> hours only have a size of approximately 160kb. even after every 10 min
> UPDATE the file growth by approximately 50-60kb !???
>
> Why does the file grow very quickly??
>
> First i thougth it is because of the multi-generation-architecture which
> stores multiple versions of an updated record, but when does firebird
> free the space for these multipe record-versions?? A database sweep does
> not help, the file continues growing in the same speed!!
>
> Yesterday I had a size of > 50MB, I did a backup and restore then the
> size was 11MB but today the size is again 20 MB !!
>
> Is this rapid growing normal or is it a bug? Does it decrease
> performance? What can I do to slower the growing?
>
> thanks for help
>
> Alex
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @... address at http://mail.yahoo.com
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

--
Lev Assinovsky Peterlink Web
Programmer St. Petersburg, Russia
Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7а
E-mail: lev@...