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