JDK 1.6 introduces Blob.free(). I believe that Blobs get cleaned
automatically when connections are freed but it's not clear (to me at
least) what happened in case of connection pools. Try forcing immediate
cleanup using Blob.free() and see if it makes a difference.
Gili
On 20/06/2011 9:26 AM, Confused wrote:
One more time maybe I won't submit before I'm done...
So I switched to Blob - but I still have 53M tied up after my commit.
If I use a null value I have< 3M after the commit. The odd think is
I'm only writing 6.5M so why the jump of 50M? I also don't see t
separate file for the blob - so am I missing something there as
well ?
I've tried adding MAX_LENGTH_INPLACE_LOB=128 to the url but that
doesn't appear to help either. I must be missing something that
prevents creating the BLOB as its own file but I can't find what may
be cause that.... I'm just the maintenance guy trying to fix the code
by someone else who didn't know what they were doing...
On Jun 20, 9:20 am, Confused<[email protected]> wrote:
I switched to blobs - I'm still seeing 53M of data tied to:
From MAT:
Class Name Shallow Heap Retained Heap>>> org.h2.store.PageStore @ 0x163a4590
176 53,714,880
pageStore org.h2.engine.Database @ 0x163a3418 296 71,688
<Java Local> java.lang.Thread @ 0x163ad630 H2 Log Writer
2FF587C5-09FA-4195-A54E-AC5CDE5311AE Thread 104 440
database org.h2.engine.Session @ 0x1640fa78 » 200 928
value java.util.HashMap$Entry @ 0x1640f070 » 24 24
database org.h2.engine.Session @ 0x1640f088 »
On Jun 18, 12:23 pm, Thomas Mueller<[email protected]>
wrote:
Hi,
If I write to a column of type binary
You have two options: BLOB and BINARY. The difference is
documented:http://h2database.com/html/datatypes.html#binary_typehttp://h2databas...
- the document says all the data is stored in memory
Where exactly does it say that?
when are the H2 buffers cleared?
It depends. There is a cache. I guess your problem is the memory usage
(when are the H2 buffers "freed").
On the next
write or after the write completes...
It depends. But about this you shouldn't worry, at least not if you use BLOB.
if my value is 2m is it cached on disk or still stored in memory.
If it's 2 MB, and if you don't have much memory, then you should
probably use BLOB.
Regards,
Thomas
--
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.
