[
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: [email protected]
For additional commands, e-mail: [email protected]
