Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 5715 invoked from network); 11 Jun 2008 12:37:05 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 11 Jun 2008 12:37:05 -0000 Received: (qmail 4431 invoked by uid 500); 11 Jun 2008 12:37:01 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 4405 invoked by uid 500); 11 Jun 2008 12:37:01 -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 4394 invoked by uid 99); 11 Jun 2008 12:37:01 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jun 2008 05:37:01 -0700 X-ASF-Spam-Status: No, hits=-0.8 required=10.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS,WHOIS_MYPRIVREG X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [192.18.6.21] (HELO gmp-eb-inf-1.sun.com) (192.18.6.21) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jun 2008 12:36:10 +0000 Received: from fe-emea-09.sun.com (gmp-eb-lb-2-fe2.eu.sun.com [192.18.6.11]) by gmp-eb-inf-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m5BCaR2R021388 for ; Wed, 11 Jun 2008 12:36:27 GMT Received: from conversion-daemon.fe-emea-09.sun.com by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0K2A00J01TFQIH00@fe-emea-09.sun.com> (original mail from Thomas.Nielsen@Sun.COM) for derby-user@db.apache.org; Wed, 11 Jun 2008 13:36:27 +0100 (BST) Received: from [129.159.112.198] by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0K2A00133TONSY60@fe-emea-09.sun.com> for derby-user@db.apache.org; Wed, 11 Jun 2008 13:36:23 +0100 (BST) Date: Wed, 11 Jun 2008 14:36:22 +0200 From: Thomas Nielsen Subject: Re: Speed of using Derby DB In-reply-to: <1c6e34b0806110523o5e1d40ackc1861cb45e9468b6@mail.gmail.com> Sender: Thomas.Nielsen@Sun.COM To: Derby Discussion Message-id: <484FC6C6.4030807@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=UTF-8 Content-transfer-encoding: 7BIT References: <1c6e34b0806110131q12339641j841b8c5861f0085a@mail.gmail.com> <484FB7BD.2060500@sun.com> <1c6e34b0806110456o5c7b581cn15b2739c875f1010@mail.gmail.com> <484FC082.2050000@sun.com> <1c6e34b0806110523o5e1d40ackc1861cb45e9468b6@mail.gmail.com> User-Agent: Thunderbird 2.0.0.14 (X11/20080505) X-Virus-Checked: Checked by ClamAV on apache.org vodarus vodarus wrote: > PS does derby / javaDB have it's own forum? > > > Do you mean outside this mailing list? > > > Yes. I think forum is more visual tool for communication than mail-list. > If so, you can read the list using nabble (www.nabble.com) :) Cheers, Thomas PS: It *may* be that the reason for the slow execution is outdated index cardinality statistics. Check out "CALL SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE" either on nabble or in the derby docs. -- Thomas Nielsen