Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <252135088.1226950784240.JavaMail.jira@brutus>
Date: Mon, 17 Nov 2008 11:39:44 -0800 (PST)
From: "Kathey Marsden (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-2975) DRDAResultSet.setResultSet creates a
 new int array to hold type information on every execution.
In-Reply-To: <2091708.1185299731036.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-2975?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12648281#action_12648281 ] 

Kathey Marsden commented on DERBY-2975:
---------------------------------------

Abhilash, are you still working on this issue? If not could you unassign yourself?


> DRDAResultSet.setResultSet creates a new int array to hold type information on every execution.
> -----------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2975
>                 URL: https://issues.apache.org/jira/browse/DERBY-2975
>             Project: Derby
>          Issue Type: Improvement
>          Components: Network Server, Newcomer, Performance
>            Reporter: Daniel John Debrunner
>            Assignee: Abhilash T.G
>            Priority: Minor
>
> Tracing the code it seems that if a statement is prepared and executed multiple times that new type information stored in DRDAResultSet is created and set every execution.
> This wastes cpu cycles as the type information can be determined once at prepare time (I assume) and stored in DRDAPreparedStatement.
> It's a little unclear to me the code path for setting the type information, seems to happen as a side effect of writing a SQLDTAGRP which seems a weird place to do it.
> (but then again I have no idea what a SQLDTAGRP is, all these DRDA "names" remind me of a Young Ones episode :-)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.