Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 94374 invoked from network); 18 Feb 2009 19:09:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 18 Feb 2009 19:09:34 -0000 Received: (qmail 37787 invoked by uid 500); 18 Feb 2009 19:09:33 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 37752 invoked by uid 500); 18 Feb 2009 19:09:33 -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 37742 invoked by uid 99); 18 Feb 2009 19:09:33 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Feb 2009 11:09:32 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [63.82.107.6] (HELO red.amberpoint.com) (63.82.107.6) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Feb 2009 19:09:25 +0000 Received: from [10.10.12.246] (bpendleton-desk.edgility.com [10.10.12.246]) by red.amberpoint.com (8.13.8/8.13.8) with ESMTP id n1IJ94mW020285 for ; Wed, 18 Feb 2009 11:09:04 -0800 Message-ID: <499C5CD0.7040503@amberpoint.com> Date: Wed, 18 Feb 2009 11:09:04 -0800 From: Bryan Pendleton User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: Derby Discussion Subject: Re: Query Compilation Drastically Increased on Join References: <64A84ACFB244464D8C7086F909034D540DB3D80C@athena.isdwhq.com> In-Reply-To: <64A84ACFB244464D8C7086F909034D540DB3D80C@athena.isdwhq.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org > offering. We have recently modified a query by adding a couple of > tables to a simple join. We have noticed a drastic increase in query > compilation time on large data sets. It's possible you're seeing this problem: https://issues.apache.org/jira/browse/DERBY-2130 There is an experimental patch attached to that issue. If possible, in your environment, it would be interesting if you can confirm whether the patch improves the behavior that you see. thanks, bryan