You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Jayaram Subramanian (JIRA)" <ji...@apache.org> on 2012/05/08 06:11:12 UTC
[jira] [Commented] (DERBY-4633) Cache default calendar in result
sets and statements on client driver
[ https://issues.apache.org/jira/browse/DERBY-4633?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13270180#comment-13270180 ]
Jayaram Subramanian commented on DERBY-4633:
--------------------------------------------
Executed the attached test program against 10.5.3 and 10.6.2 and got the following results..
Elapsed Seconds =131
2012-05-08 04:04:40.883 GMT : Apache Derby Network Server - 10.5.3.0 - (802917)
shutdown
Elapsed Seconds =113
2012-05-08 04:09:26.820 GMT : Apache Derby Network Server - 10.6.2.1 - (999685)
shutdown
> Cache default calendar in result sets and statements on client driver
> ---------------------------------------------------------------------
>
> Key: DERBY-4633
> URL: https://issues.apache.org/jira/browse/DERBY-4633
> Project: Derby
> Issue Type: Improvement
> Components: JDBC, Network Client
> Affects Versions: 10.6.1.0
> Reporter: Knut Anders Hatlen
> Labels: derby_triage10_9
>
> After the changes in DERBY-4582, these methods now allocate a default calendar object on each invocation (on the client driver), whereas they didn't before the fix:
> ResultSet.getDate(int)
> ResultSet.getTime(int)
> ResultSet.getTimestamp(int)
> PreparedStatement.setDate(int, java.sql.Date)
> PreparedStatement.setTime(int, java.sql.Time)
> PreparedStatement.setTimestamp(int, java.sql.Timestamp)
> CallableStatement.getDate(int)
> CallableStatement.getTime(int)
> CallableStatement.getTimestamp(int)
> The embedded driver prevents excessive allocation of default calendar objects in these methods by caching an instance in ConnectionChild (the super-class of EmbedResultSet, EmbedPreparedStatement and EmbedCallableStatement). We should do something similar on the client driver.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira