Subject Re: [ib-support] Re: DB-file growth VERY rapidly!??
Author lester@lsces.co.uk
> ok, I have sent the perl script to you... hope it will arrive....
>
> --- In ib-support@y..., Lev Assinovsky <lev@p...> wrote:
> > Seems, you accidentally insert the records (explicitly or implicitly).
> > Could you send me your perl script?

Changes to the database structure will not affect this
problem.

This is a matter of HOW the perl script is being run, and
probably a bug in that area.

We need to know WHAT is connected when the update happens,
as that will determine if the multiple copies of the data
are being maintained. You said that the sweeping does not
affect the rate of growth, so are there more records in the
database than you actually expect? In my case, the raw data
never exceeded 5Mb, but the database would double every 15
mins, so is the situation that your database actually has
more data than you expect?

You said initially that 50Mb when down to 11Mb. If that is
the case, then we should be able to 'reset' the databse to
re-use the 39Mb without a backup and restore.

I think there are two things going on here. More data than
you expect along with growth due to the additional data
records and the way transactions are being handled.

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