db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sunitha Kambhampati <ksunitha...@gmail.com>
Subject Re: BLOB : java.lang.OutOfMemoryError
Date Fri, 02 Sep 2005 16:35:18 GMT
Rajes Akkineni wrote:

> Hi,
>
> Dose that mean if i have 4 tables with BLOBs it will take up 120mb ~?

No, it does not depend on the tables in database.  Page cache is per 
database.

Sunitha.


<snip>

>
> On Thu, 01 Sep 2005 23:32:40 +0530, Sunitha Kambhampati  
> <ksunithaghm@gmail.com> wrote:
>
>> Rajes Akkineni wrote:
>>
>>> Hi,
>>>
>>> I have got the similar problem.
>>
>>
>>> I was unable to insert bigger files in to the database.
>>> But my situation is little different than this. I am not inserting  
>>> total  40mb file in one blob.
>>> I have split them in to 64kb chunks and inserting in multiple rows.
>>>
>>> I got outofmemory error.
>>
>>
>> Are you using embedded driver or the network client driver ?  I 
>> think  the issue discussed in this earlier thread is referring to the 
>> client  driver. ( -DERBY-326).  But if you are  noticing the  problem 
>> with  embedded,  it would be great if you could post a reproduction 
>> program,  so we can take a look.
>>
>> I have tested inserting 1000 rows of 64kb blobs on my T40 laptop and 
>> it  works ok both with default jvm heap size and also with 
>> restricting the  jvm max heap size to 40mb. Note by default , for a 
>> table containing blob  column, page size is 32k and page cache is 
>> 1000 pages, so the pagecache  would take about 32mb of memory.
>>


Mime
View raw message