Return-Path: 
 <derby-user-return-7187-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 77685 invoked from network); 12 Jul 2007 17:54:27 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 12 Jul 2007 17:54:27 -0000
Received: (qmail 22564 invoked by uid 500); 12 Jul 2007 17:54:28 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 22537 invoked by uid 500); 12 Jul 2007 17:54:28 -0000
Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-user-help@db.apache.org>
list-unsubscribe: <mailto:derby-user-unsubscribe@db.apache.org>
List-Post: <mailto:derby-user@db.apache.org>
List-Id: <derby-user.db.apache.org>
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Delivered-To: mailing list derby-user@db.apache.org
Received: (qmail 22526 invoked by uid 99); 12 Jul 2007 17:54:28 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jul 2007 10:54:28 -0700
X-ASF-Spam-Status: No, hits=3.2 required=10.0
	tests=DNS_FROM_AHBL_RHSBL,HTML_10_20,HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of bordia@gmail.com designates
 209.85.132.241 as permitted sender)
Received: from [209.85.132.241] (HELO an-out-0708.google.com) (209.85.132.241)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jul 2007 10:54:25 -0700
Received: by an-out-0708.google.com with SMTP id c8so48543ana
        for <derby-user@db.apache.org>; Thu, 12 Jul 2007 10:54:04 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed;
        d=gmail.com; s=beta;
        h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
        b=YU/RI3doCjOT4A56JfXlJZ6PzBgiuhVpF40hjIJ8sT/ChT8vMNM+VUsglyBnC3aolRQX7YvLOzJL/ZYYdpBXHbYPczExffBZFXNGFnEwRswq6mOBZHOmXmv8oE3PIcEkAXtv3oWHQPiHTTa4fSw9kmJBWKxPQNi5dEFfyrsrejI=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:mime-version:content-type;
        b=Tj5w5F/tSq+M+J4Zn2OFzfdbu2HXEhJY8MJAuJ+huE5SpXGzFNKXKIf5TN15gd3Z9A1W6tB/TLzngj8T5tFjy9lcfqWcPwTg6Za+R+DoS6+xwaSPd2trTHJATYmeMpnKP7VxuLk8wl46jae0GvTbRhRSrvQBL0QD92B/bi3/068=
Received: by 10.100.119.14 with SMTP id r14mr432746anc.1184262844055;
        Thu, 12 Jul 2007 10:54:04 -0700 (PDT)
Received: by 10.100.45.9 with HTTP; Thu, 12 Jul 2007 10:54:03 -0700 (PDT)
Message-ID: <5ba791c80707121054v680890e3t767ab234dc38f981@mail.gmail.com>
Date: Thu, 12 Jul 2007 10:54:03 -0700
From: "Aakash Bordia" <bordia@gmail.com>
To: derby-user@db.apache.org
Subject: how to trace the optimizer and derby in general?
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_25797_16992853.1184262843932"
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_25797_16992853.1184262843932
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi, I am trying to generate an optimizer trace, with the following
properties:
derby.language.OptimizerTrace=true (not sure if its case sensitive)
derby.language.optimizerTrace=true
derby.language.optimizerTraceHtml=true

I see optimizerTrace and optimizerTraceHtml as members of the OptimizerImpl
class. But this does not seem to generate a stack trace for the optimizer.
The only thing I was able to get to work was:
derby.debug.true=DumpOptimizedTree //this only dumps the tree, but not the
tracing

How could I get the optimizer to trace itself in derby.log or some file?
(also derby in general).

Not sure if this is a question for derby-dev actually?

Thanks
Aakash

------=_Part_25797_16992853.1184262843932
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hi, I am trying to generate an optimizer trace, with the following properties:</div>
<div>derby.language.OptimizerTrace=true (not sure if its case sensitive)<br>derby.language.optimizerTrace=true<br>derby.language.optimizerTraceHtml=true</div>
<div>&nbsp;</div>
<div>I see optimizerTrace and optimizerTraceHtml as members of the OptimizerImpl class. But this does not seem to generate a stack trace for the optimizer. The only thing I was able to get to work was:</div>
<div>derby.debug.true=DumpOptimizedTree //this only dumps the tree, but not the tracing</div>
<div>&nbsp;</div>
<div>How could I get the optimizer to trace itself in derby.log or some file? (also derby in general).</div>
<div>&nbsp;</div>
<div>Not sure if this is a question for derby-dev actually?</div>
<div>&nbsp;</div>
<div>Thanks</div>
<div>Aakash</div>

------=_Part_25797_16992853.1184262843932--