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: Out of Memory
Date Mon, 15 May 2006 18:37:11 GMT
Michael Andreasen wrote:

> Here is a demo.
>
> It will run ok on my desktop with -Xmx8m. However, I'm using the 
> database for real on a CDC device and 8 meg is about the total memory 
> I have for the database and the snall application together, so I'd 
> really like derby to operate in 4 or 6 meg tops. Speed is not top 
> priority here, so long as it actually operates. However, using -Xmx6m 
> or less, I can't even get the test to complete without running out of 
> memory.

The default page cache size of derby is 1000 pages and depending on the 
schema the default page size can vary and the max pagesize can be 32k. 

You could reduce the pagecache size by setting the following properties 
derby.storage.pageSize=4096
derby.storage.pageCacheSize=40

References:
http://db.apache.org/derby/docs/10.1/tuning/rtunproper40688.html
http://db.apache.org/derby/docs/10.1/tuning/rtunproper40688.html
http://db.apache.org/derby/faq.html#derby_faster

HTH,
Sunitha.

Mime
View raw message