From derby-dev-return-28880-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Fri Sep 01 20:09:41 2006 Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 29513 invoked from network); 1 Sep 2006 20:09:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 1 Sep 2006 20:09:37 -0000 Received: (qmail 74644 invoked by uid 500); 1 Sep 2006 20:09:31 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 74601 invoked by uid 500); 1 Sep 2006 20:09:31 -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 74567 invoked by uid 99); 1 Sep 2006 20:09:31 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Sep 2006 13:09:31 -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 [68.142.198.208] (HELO smtp109.sbc.mail.mud.yahoo.com) (68.142.198.208) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 01 Sep 2006 13:09:30 -0700 Received: (qmail 2502 invoked from network); 1 Sep 2006 20:09:08 -0000 Received: from unknown (HELO ?127.0.0.1?) (ddebrunner@sbcglobal.net@75.24.104.226 with plain) by smtp109.sbc.mail.mud.yahoo.com with SMTP; 1 Sep 2006 20:09:08 -0000 Message-ID: <44F8935F.6000808@apache.org> Date: Fri, 01 Sep 2006 13:09:03 -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: The perils of complexity - CURRENT TIME handling References: <44F766E2.4000304@apache.org> In-Reply-To: <44F766E2.4000304@apache.org> 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 Daniel John Debrunner wrote: > Hence all this complexity lead to significantly increased memory usage > in the ResultSet tree and saving of one field in the activation. Exactly > the opposite effect that was intended!! Turns out to be even worse. All the close cleanup method stuff has no functional benefit. If a statement is using current time expressions then its execute method always performs the reset (forget) of the time values. The only value to the code would be to allow up to three objects to be garbage collected sooner, either inbetween executions or between the time of the last execution and the time the statement is closed. Simply not worth it. Dan.