i have already sweeped the db a few times, shut down and restarted the
server and the db, but after doing 2038 updates in a transaction
every 10 minutes, the db-file-size increases aproximately 8 MB (!!)
per day! also there are only updates during the day! at 0.00am 2038
new records are inserted (size of inserted data approximately 150kb)
every day.

But the curios is the growing file-size after EACH UPDATE, and this
space is never freed&used again, the file-size growth and growth!!

this can't be normal! assume i will let rund my application for 100
days, this would mean a DB-file-size of 800 MB but the real data size
would only be 16 MB (203800 records).

It seems that the multi-generation-architecture does not free old
record versions!!!


HELP!!

--- In ib-support@y..., Aage Johansen <aagjohan@o...> wrote:

>
> I haven't been following all of this so this may have been covered
(or be
> off track):
> What does the statistics (of the header page) say? Maybe you have a
> 'stuck transaction' and need to shutdown the database and do a sweep
before
> restarting.
>
> Regards,
> Aage J.