Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 63385 invoked from network); 13 Apr 2006 14:18:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 13 Apr 2006 14:18:19 -0000 Received: (qmail 85858 invoked by uid 500); 13 Apr 2006 14:18:01 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 85636 invoked by uid 500); 13 Apr 2006 14:18:00 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 85623 invoked by uid 99); 13 Apr 2006 14:18:00 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Apr 2006 07:18:00 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=MANY_EXCLAMATIONS,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [192.18.98.31] (HELO brmea-mail-1.sun.com) (192.18.98.31) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Apr 2006 07:17:59 -0700 Received: from phys-d3-ha21sca-1 ([129.145.155.163]) by brmea-mail-1.sun.com (8.12.10/8.12.9) with ESMTP id k3DEHc3d014389 for ; Thu, 13 Apr 2006 08:17:39 -0600 (MDT) Received: from conversion-daemon.ha21sca-mail1.sfbay.sun.com by ha21sca-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <0IXN00A01ZIK9X@ha21sca-mail1.sfbay.sun.com> (original mail from Richard.Hillegas@Sun.COM) for derby-dev@db.apache.org; Thu, 13 Apr 2006 07:17:35 -0700 (PDT) Received: from [129.150.21.243] (vpn-129-150-21-243.SFBay.Sun.COM [129.150.21.243]) by ha21sca-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTP id <0IXN00MVXZPBPD@ha21sca-mail1.sfbay.sun.com> for derby-dev@db.apache.org; Thu, 13 Apr 2006 07:17:35 -0700 (PDT) Date: Thu, 13 Apr 2006 07:17:48 -0700 From: Rick Hillegas Subject: Re: !$!% derbyall In-reply-to: <443E5910.5050803@gmail.com> To: derby-dev@db.apache.org Message-id: <443E5D8C.9020702@sun.com> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) References: <443D9716.5090502@sun.com> <443E47A2.4040504@sun.com> <443E5910.5050803@gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi Army, This is probably the issue I was referring to. If it's resolved, that's great. Thanks, -Rick Army wrote: > Rick Hillegas wrote: > >> 2) I seem to recall that, earlier this year, optimizer modifications >> bloated up the the per-query running time. > > > Ummm...I think I'm the only one who has made optimizer modifications > this year, so I guess that's a reference to me. Are you thinking > about any changes in particular? > > So far as I know, derbyall was taking just as long after each of my > changes as it was before, with the exception of the nist suite > slow-down that Ole pointed out (which has, I *think*, been resolved?) > and some (expected) extra time for the extra test cases that I've added. > > I'm not denying this, but it'd be great if you could give the specific > Jira issues and/or test results that are the basis of this statement. > If we're seeing significant slow-down because of my optimizer changes, > then a) something is probably wrong, and b) I wish someone would have > said something sooner... > > Army >