db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Fox (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (TORQUE-141) Adding a way to set JDBC Driver fetchSize on statement
Date Sun, 04 Mar 2012 13:27:59 GMT

    [ https://issues.apache.org/jira/browse/TORQUE-141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13221884#comment-13221884

Thomas Fox commented on TORQUE-141:

It seems that the default prefetch size can be set on the database connection (http://docs.oracle.com/cd/B10500_01/java.920/a96654/oraperf.htm#1002425).
This should be possible by passing connection properties to the pool, see the commons-dbcp
docs (http://commons.apache.org/dbcp/configuration.html). Any reason why this does not suffice

> Adding a way to set JDBC Driver fetchSize on statement
> ------------------------------------------------------
>                 Key: TORQUE-141
>                 URL: https://issues.apache.org/jira/browse/TORQUE-141
>             Project: Torque
>          Issue Type: Improvement
>          Components: Runtime, Village
>    Affects Versions: 3.3
>         Environment: All
>            Reporter: GBT
>         Attachments: fetchSize.patch
>   Original Estimate: 24h
>  Remaining Estimate: 24h
> With the current version, it's not possible to set the fetchsize on statements (see method
setFetchSize on Statement) in order to optimize the roundtrips with the database. The default
value is set by the JDBC Driver, for Oracle the value is 10.

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


To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org

View raw message