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.
