Subject Re: [firebird-support] High volume of INSERT/DELETE operations
Author Kjell Rilbe
Doychin Bondzhev wrote:

> I'm trying to use Firebird as persistence container for JBossMQ.
> It is a system that produces lots of messages so there are many
> inserts and corresponding delete operations in one table(JMS_MESSAGES).
> So the problem I have is that firebird database grows to much while
> there are only just a few records in that table.
> Any ideas what I have to change or set in order to protect my database
> from growing to much while there are not that much number of records?
> I'm talking here for 500000 or more inserts and deletes per day.

If all transactions are properly committed, the DB should grow up to a
certain point to make room for the max number of existing records, and
then not grow much more. Space for deleted records will be reused.

If the DB keeps growing, then you probably have uncommitted transactions
lying around.

Kjell Rilbe
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64