Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 24605 invoked from network); 25 Mar 2008 20:00:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 25 Mar 2008 20:00:37 -0000 Received: (qmail 52498 invoked by uid 500); 25 Mar 2008 20:00:34 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 52358 invoked by uid 500); 25 Mar 2008 20:00:34 -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 52347 invoked by uid 99); 25 Mar 2008 20:00:34 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 25 Mar 2008 13:00:34 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of gcaddu-derby-user@m.gmane.org designates 80.91.229.2 as permitted sender) Received: from [80.91.229.2] (HELO ciao.gmane.org) (80.91.229.2) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 25 Mar 2008 19:59:44 +0000 Received: from root by ciao.gmane.org with local (Exim 4.43) id 1JeFJS-0007mQ-Vq for derby-user@db.apache.org; Tue, 25 Mar 2008 20:00:03 +0000 Received: from yktgi01e0-s5.watson.ibm.com ([129.34.20.19]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 25 Mar 2008 20:00:02 +0000 Received: from acade4u by yktgi01e0-s5.watson.ibm.com with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 25 Mar 2008 20:00:02 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: derby-user@db.apache.org From: Guillermo Averboch Subject: derby.storage.pageCacheSize on multiple databases Date: Tue, 25 Mar 2008 19:55:15 +0000 (UTC) Lines: 13 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: main.gmane.org User-Agent: Loom/3.14 (http://gmane.org/) X-Loom-IP: 129.34.20.19 (Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648)) Sender: news X-Virus-Checked: Checked by ClamAV on apache.org Hi, I'm a fairly new Derby user, and I can't seem to find the answer to this question anywhere: How does derby.storage.pageCacheSize work when the same process has several opened Derby databases at the same time? According to the Derby documentation, derby.storage.pageCacheSize is system- wide, hence individual databases cannot set their own value for it. Does this mean that there is only one cache, which is shared by all databases, or that Derby creates separate caches for each database, each of which can grow up to the size specified by derby.storage.pageCacheSize? Thanks so much, Guillermo