|Re: Setting jdbc fetch size for dataset [message #483479 is a reply to message #483456]
||Tue, 01 September 2009 17:25
| James Koch
Registered: July 2009
To clarify, since the link back to the original post doesn't appear to be |
working, Oracle's JDBC driver defaults to a fetch size of 10, meaning that
to retrieve 6000 rows the JDBC driver does 600 round-trips to the DB.
It's a common best practice to increase this value for data sets with many
We're seeing BIRT (via JDBC) severely under-performing Oracle's query
tools on a data set of this size, and would like to try tweaking this.
I'm no JDBC expert, but it looks like Statement.setFetchSize() is the only
way to set it. Oracle has some Connection-level properties that serve as
defaults for all Statements issued on that Connection, but I don't think
that's a JDBC standard.
I've been toying w/ the debugger to see if I could use an event handler to
navigate from the ODA data source/set down to an underlying JDBC
connection/statement, but I'm getting nowhere.
Other alternatives I've considered are:
- Building a custom ODA source; ouch!
default FetchSize, then using "OdaJDBCDriverPassInConnection" to force
that connection into my Data Source.
Powered by FUDForum
. Page generated in 0.01812 seconds