> Currently empty space in the database file is re-used at runtime. If
> you delete a lot of data, and then add a lot of data, the empty space
> is re-used. The database file only grows if there is no more empty
> space.
Hi
I am not sure that this is working as intended. I am experimenting
with using H2 1.2.137 as an embedded persistence store for ActiveMQ.
Unfortunately the database is continously growing, even when I
completely clear every table. As soon as new messages get inserted, it
grows.
Whats special about ActiveMQ is heavy use of blobs. Its main message
table is declared as:
CREATE CACHED TABLE PUBLIC.ACTIVEMQ_MSGS(
ID BIGINT NOT NULL,
CONTAINER VARCHAR(250),
MSGID_PROD VARCHAR(250),
MSGID_SEQ BIGINT,
EXPIRATION BIGINT,
MSG BLOB
)
Regards
Alex
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
