Okay blobs are woring now that I found the cached string that was
creating the table as varbinary... My predecessor imported the string
into another class to create the table and the class wasn't updating
when the I changed the containing file...
That said if I now use Blob the memory usage is about 3m - much better
than 53m. If I turn on the define for not storing blobs as separate
files it now takes 14m - which is odd for a 6.5m string. It appears to
have 2 copies cached.... Any idea why?
For reference on insert:
InputStream in = new ByteArrayInputStream(MyByteArray);
ps.setBinaryStream(3, in);
ps.executeUpdate();
rs = ps.getGeneratedKeys();
if(typedData != null)
logger.debug( "Created {} Typed_data Size :",
typedData.length );
ps.clearParameters();
On Jun 20, 3:23 pm, Thomas Mueller <[email protected]>
wrote:
> Hi,
>
> > So I switched to Blob - but I still have 53M tied up after my commit.
>
> Could you run this query and post the result? SELECT * FROM
> INFORMATION_SCHEMA.SETTINGS (I'm mainly interested in the H2 version,
> and the cache size).
>
> Could you try to find out what inside the PageStore is using that much
> memory? Probably it's the cache, but just to be sure. To find out,
> run:
>
> jps -l (to get the process id)
> jmap -histo <pid> (to get the the object list)
>
> 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.
