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
<[EMAIL PROTECTED]> 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.
