db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-4633) Cache default calendar in result sets and statements on client driver
Date Wed, 22 Feb 2012 08:06:48 GMT

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

Knut Anders Hatlen commented on DERBY-4633:
-------------------------------------------

A good first step might be to run experiments to find out if fetching a large number of Time/Date/Timestamp
objects via the client driver was slowed down between 10.5.3 and 10.6.2. If it turns out that
the difference is small, it's probably better that we keep the code simple and don't add the
extra complexity.
                
> 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

        

Mime
View raw message