> 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??

Have you closed and re-opened the 'client' programs?

This is typical of a problem I had many moons ago, when
using BDE to talk to IB6. If there is a connection being
held open, the the multi-generation bit kickes in, and lots
of copies are made. Drop all connections (?Sweep with a new
connection - it was some time ago) and then re-make the
connections, and then the size stops growing until the
'slack' is taken up again. If this is the case -> then ->

You need to establich WHAT is keeping a transaction open
that requires the old copies of the data.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services