From derby-user-return-12981-apmail-db-derby-user-archive=db.apache.org@db.apache.org Tue Jul 20 18:37:53 2010 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 47093 invoked from network); 20 Jul 2010 18:37:53 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 20 Jul 2010 18:37:53 -0000 Received: (qmail 17123 invoked by uid 500); 20 Jul 2010 18:37:53 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 17006 invoked by uid 500); 20 Jul 2010 18:37:52 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 16999 invoked by uid 99); 20 Jul 2010 18:37:52 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Jul 2010 18:37:52 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of david.vancouvering@gmail.com designates 74.125.83.44 as permitted sender) Received: from [74.125.83.44] (HELO mail-gw0-f44.google.com) (74.125.83.44) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Jul 2010 18:37:46 +0000 Received: by gwj19 with SMTP id 19so3338321gwj.31 for ; Tue, 20 Jul 2010 11:37:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:sender:received:from:date :x-google-sender-auth:message-id:subject:to:content-type; bh=gB1iwAphxABA4GCoiDZi+2GQy6tqrnk86He84zPfRvg=; b=bjz4X+5SEqhyJDwO04My2OtMwmcZpjK9sUakFyPFk+dS2y9kEUR5/hUAKdve33hE2v rO8uUjKg9IEihmmffpg/bugz4eSOxMhb4o2pZhVBiN/T0FBFtIHXXRhalR72xxwW6cx6 GVGHgC9UHouSy9qag5nnO9uTjtYQo0IktjYJk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:from:date:x-google-sender-auth:message-id :subject:to:content-type; b=giBP7Jt+ELXu3Ahnfyx/N3OYs9hY/XOkfULHKfhVTAqHT4CR/d3wPMMYCBhUqbWBdP T6sI0NY0dPx4LLw0gJ4J5IWAQqqSD8aSzGaFc8FAMYLdLEsIUdwBM36PQMzvqYGmYdqq C+YkEAUPKwAYS0YvkK0dgfJIdJtFlkgRKdVOs= Received: by 10.151.139.16 with SMTP id r16mr827458ybn.168.1279651044432; Tue, 20 Jul 2010 11:37:24 -0700 (PDT) MIME-Version: 1.0 Sender: david.vancouvering@gmail.com Received: by 10.231.199.68 with HTTP; Tue, 20 Jul 2010 11:37:04 -0700 (PDT) From: David Van Couvering Date: Tue, 20 Jul 2010 11:37:04 -0700 X-Google-Sender-Auth: 39Bpq-uiWHLPlMfS-E41lnKOM4o Message-ID: Subject: Reducing memory footprint of embedded Derby To: Derby Discussion Content-Type: multipart/alternative; boundary=000e0cd72db0f09cbc048bd5f9d9 X-Virus-Checked: Checked by ClamAV on apache.org --000e0cd72db0f09cbc048bd5f9d9 Content-Type: text/plain; charset=ISO-8859-1 Hi, all. Could you point me to a page, or just tell me, what configuration settings I can tweak to reduce the overall memory footprint of a booted Derby database. Losing performance is pretty much OK, this is not a time-critical part of our code, but I have a lot of databases open and it's impacting memory footprint pretty significantly. I already reduced the page cache size, what else? Thanks! David -- David W. Van Couvering http://www.linkedin.com/in/davidvc http://davidvancouvering.blogspot.com http://twitter.com/dcouvering --000e0cd72db0f09cbc048bd5f9d9 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi, all.=A0 Could you point me to a page, or just tell me, what configurati= on settings I can tweak to reduce the overall memory footprint of a booted = Derby database.=A0 Losing performance is pretty much OK, this is not a time= -critical part of our code, but I have a lot of databases open and it's= impacting memory footprint pretty significantly.

I already reduced the page cache size, what else?

Thanks!
David

--
David W. Van Couvering

http://www.linkedin.com/in/davidvc=
http://davidvancouvering.= blogspot.com
http://twitte= r.com/dcouvering
--000e0cd72db0f09cbc048bd5f9d9--