[
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.
