Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 41250 invoked from network); 28 Nov 2008 17:52:28 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 28 Nov 2008 17:52:28 -0000 Received: (qmail 2400 invoked by uid 500); 28 Nov 2008 17:52:38 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 2376 invoked by uid 500); 28 Nov 2008 17:52:38 -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 2358 invoked by uid 99); 28 Nov 2008 17:52:38 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Nov 2008 09:52:38 -0800 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Nov 2008 17:51:10 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1L67VU-00015W-LW for derby-user@db.apache.org; Fri, 28 Nov 2008 09:51:56 -0800 Message-ID: <20738167.post@talk.nabble.com> Date: Fri, 28 Nov 2008 09:51:56 -0800 (PST) From: Reda134 To: derby-user@db.apache.org Subject: How to force Derby to release memory in embedded mode MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: reda134@gmail.com X-Virus-Checked: Checked by ClamAV on apache.org Hi all, I use Derby in the embedded mode to join 2 Tables that can be huge. I remarked that Derby doesnt release the space allocated during the join after proceeding it. If i want to perform a second join i get an outofmemory error... So my question is, is there a way to force Derby to give up the allocated memory ?? Many thanks. Reda -- View this message in context: http://www.nabble.com/How-to-force-Derby-to-release-memory-in-embedded-mode-tp20738167p20738167.html Sent from the Apache Derby Users mailing list archive at Nabble.com.