Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 44661 invoked from network); 19 Jan 2006 18:19:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 19 Jan 2006 18:19:06 -0000 Received: (qmail 70634 invoked by uid 500); 19 Jan 2006 18:19:05 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 70601 invoked by uid 500); 19 Jan 2006 18:19:05 -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 70592 invoked by uid 99); 19 Jan 2006 18:19:05 -0000 X-ASF-Spam-Status: No, hits=1.3 required=10.0 tests=SPF_FAIL X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Jan 2006 10:19:04 -0800 Received: from ajax.apache.org (ajax.apache.org [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id 6158DCB for ; Thu, 19 Jan 2006 19:18:43 +0100 (CET) Message-ID: <690613046.1137694723396.JavaMail.jira@ajax.apache.org> Date: Thu, 19 Jan 2006 19:18:43 +0100 (CET) From: "Rajesh Kartha (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Assigned: (DERBY-808) PreparedStatements can take longer to execute than Statements. There seem to be a problem with searchClauseTransitiveClosure method in PredicateList.java In-Reply-To: <1774083642.1137029900284.JavaMail.jira@ajax.apache.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 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 [ http://issues.apache.org/jira/browse/DERBY-808?page=all ] Rajesh Kartha reassigned DERBY-808: ----------------------------------- Assign To: Rajesh Kartha > PreparedStatements can take longer to execute than Statements. There seem to be a problem with searchClauseTransitiveClosure method in PredicateList.java > --------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-808 > URL: http://issues.apache.org/jira/browse/DERBY-808 > Project: Derby > Type: Bug > Components: SQL > Versions: 10.1.2.0, 10.2.0.0 > Environment: generic > Reporter: Satheesh Bandaram > Assignee: Rajesh Kartha > Fix For: 10.2.0.0, 10.1.3.0, 10.1.2.2 > Attachments: DERBY-808.patch > > PreparedStatements could take much longer than Statements because of incorrect search clause transitive closure optimization. For the customer case I investigated this problem, Statement would complete in about 13 seconds, where as equivalent PreparedStatement ran "forever". (stoped it after hours) > I think there a problem with PredicateList.searchClauseTransitiveClosure method. This method tries to add new search clauses based on equality join between tables involved. Current code only looks for ConstantNodes on the right side of searchClauses. This would miss ParameterNodes, so Derby might miss search clause transitive closure optimizations for PreparedStatements. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira