Subject | High volume of INSERT/DELETE operations |
---|---|
Author | Doychin Bondzhev |
Post date | 2008-12-12T11:29:34Z |
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.
Thanks in advance
Doychin Bondzhev
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.
Thanks in advance
Doychin Bondzhev