Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 99583 invoked from network); 9 Aug 2006 00:16:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 9 Aug 2006 00:16:40 -0000 Received: (qmail 59994 invoked by uid 500); 9 Aug 2006 00:16:40 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 59957 invoked by uid 500); 9 Aug 2006 00:16:39 -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 59948 invoked by uid 99); 9 Aug 2006 00:16:39 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Aug 2006 17:16:39 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [32.97.110.151] (HELO e33.co.us.ibm.com) (32.97.110.151) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Aug 2006 17:16:39 -0700 Received: from westrelay02.boulder.ibm.com (westrelay02.boulder.ibm.com [9.17.195.11]) by e33.co.us.ibm.com (8.12.11.20060308/8.12.11) with ESMTP id k790GI0S027993 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=FAIL) for ; Tue, 8 Aug 2006 20:16:18 -0400 Received: from d03av02.boulder.ibm.com (d03av02.boulder.ibm.com [9.17.195.168]) by westrelay02.boulder.ibm.com (8.13.6/NCO/VER7.0) with ESMTP id k790GI8j266288 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 8 Aug 2006 18:16:18 -0600 Received: from d03av02.boulder.ibm.com (loopback [127.0.0.1]) by d03av02.boulder.ibm.com (8.12.11.20060308/8.13.3) with ESMTP id k790GHMF013148 for ; Tue, 8 Aug 2006 18:16:18 -0600 Received: from [127.0.0.1] (DMCSDJDT41P.usca.ibm.com [9.72.133.68]) by d03av02.boulder.ibm.com (8.12.11.20060308/8.12.11) with ESMTP id k790GGsn013086 for ; Tue, 8 Aug 2006 18:16:17 -0600 Message-ID: <44D9294F.40508@apache.org> Date: Tue, 08 Aug 2006 17:16:15 -0700 From: Daniel John Debrunner User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: en-us, en, de MIME-Version: 1.0 To: derby-dev@db.apache.org Subject: Re: [jira] Commented: (DERBY-1315) largeCodeGen fails with embedded and framework DerbyNetClient References: <15785947.1155069494307.JavaMail.jira@brutus> <44D8FA1C.4050103@apache.org> <44D8FEF0.7050809@gmail.com> In-Reply-To: <44D8FEF0.7050809@gmail.com> X-Enigmail-Version: 0.90.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Army wrote: > Daniel John Debrunner wrote: > >> >> Any pointers to the type of extra state kept around. Is it query tree >> nodes, collections, something else? > > > With Phase 1 of DERBY-805, a HashMap was added to each query tree node. > The map holds an Object->AccessPathImpl mapping for each OptimizerImpl > that occurs above the node in the query tree. The "Object" in this > mapping is an object that already existed; the AccessPathImpl is a new > object. > > See FromTable.addOrLoadBestPlanMapping() > > With Phase 4, additional entries to the HashMap are added for every > UnionNode, PRN, or JoinNode that occurs above the node...and also for > every occurrence of a node that doesn't implement "optimizeIt()". I don't see anything ever being removed from these hashMaps. Is it possible to remove entries at any time? Dan.