I also did some more experiments playing with the lob-settings.
System.setProperty("h2.defaultMaxLengthInplaceLob", "512");
This forces the system to write the lobs dir - my messages really are
smaller then the 4k default.
The behaviour is like this:
- h2.db still grows, of course much smaller than before
- the lobs-dir grows too. Individual lob-directories are empty - but
the number of directories grows and grows and...
- ActiveMQ througput is about 4x slower than with the defaults
System.setProperty("h2.lobInDatabase", "true");
System.setProperty("h2.defaultMaxLengthInplaceLob2", "4096");
No change, to my first mail, h2.db grows.
Whats also strange: When I start to delete the file also grows, but
much less than inserting. Perhaps there is some transaction log
somewhere which doesnt get ever cleaned out ?
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.
