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.
>>
|