db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristian Waagan (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3313) JDBC client driver statement cache
Date Thu, 10 Jan 2008 22:38:34 GMT

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

Kristian Waagan commented on DERBY-3313:

Thanks for giving feedback on the overview Dan.

I was not aware of what you state about the cache in the embedded driver, and this was useful
information. I will clarify the wording in the overview, and also think about the possibility
to share code between both drivers.

Just out of curiosity, how much work do you think is saved/avoided by the current scheme when
it comes to re-preparing a statement in the embedded driver?
Are we talking about less then 10%, something like 50% or more than that?
I'm just looking for an indication of how much can be gained from caching JDBC statement objects
in the embedded driver.

Right now I'm not convinced the code can be shared directly and easily. From what I have seen
previously, entering the realm of code sharing between the two drivers can result in quite
a lot more work. I will keep it in the back of my head though, and try to make the right choices
happen if sharing seems feasible.

> JDBC client driver statement cache
> ----------------------------------
>                 Key: DERBY-3313
>                 URL: https://issues.apache.org/jira/browse/DERBY-3313
>             Project: Derby
>          Issue Type: New Feature
>          Components: JDBC, Network Client
>    Affects Versions:
>            Reporter: Kristian Waagan
>            Assignee: Kristian Waagan
>             Fix For:
>         Attachments: JDBCClientStatementCacheOverview.txt
> A statement cache in the JDBC client driver will help increase performance in certain
scenarios, for instance some multi-tier systems using connection pooling.
> Please consult the comments and documents attached to this issue for more information.

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

View raw message