|
Re: Setting jdbc fetch size for dataset [message #367955 is a reply to message #367939] |
Wed, 22 April 2009 04:02 |
Eclipse User |
|
|
|
Originally posted by: johnw.innoventsolutions.com
If your using the API, wouldn't IRunTask.setMaxRowsPerQuery(int) work? I
haven't tried it first hand...
john mcteague wrote:
> Is it possible to set the fetch size for a dataset? Ive examined the api
> and can find no mention of this capability. Is it simply missing?
>
> Thanks.
>
|
|
|
|
|
Re: Setting jdbc fetch size for dataset [message #483479 is a reply to message #483456] |
Tue, 01 September 2009 17:25 |
James Koch Messages: 23 Registered: July 2009 |
Junior Member |
|
|
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
rows.
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!
- Building a connection in Java/JavaScript, setting the Oracle-specific
default FetchSize, then using "OdaJDBCDriverPassInConnection" to force
that connection into my Data Source.
|
|
|
|
Re: Setting jdbc fetch size for dataset [message #801001 is a reply to message #800653] |
Fri, 17 February 2012 20:04 |
|
I believe this was in 2.3.2. If you are using the viewer add
&__maxrows=5 to the url to test it.
Jason
On 2/17/2012 5:13 AM, Anantasrinivas Lakshmanan wrote:
> Hi,
>
> Is this feature available in BIRT 2.3.2. We are using BIRT 2.3.2 and we
> are very close to going live, so we cannot move to the new version. So
> is the feature of setting the JDBC Fetch Size available in BIRT 2.3.2?
>
> Thanks,
> Ananta
|
|
|
|
Re: Setting jdbc fetch size for dataset [message #803637 is a reply to message #802570] |
Tue, 21 February 2012 15:59 |
|
I checked the 2.3.2 source and that property does not exist. If you
have to have it in 2.3.2 you will need to modify the code or implement a
driverBridge extension point like what is described here:
http://birtworld.blogspot.com/2007/01/birt-connection-pooling-continued.html
Jason
On 2/20/2012 12:42 AM, Anantasrinivas Lakshmanan wrote:
> Hi Jason,
>
> Thanks for your response.
> The maxRows is available but i want the settings for RowFetchSize which
> is the number of rows retreived from the DB to the app server in one
> request. I dont want to restrict the number of rows returned but i want
> to reduce the number of calls to the DB for getting the result set.
> In 2.6.1 i see a parameter rowFecthSize whcih does this task.
>
> Thanks,
> Ananta.
|
|
|
Powered by
FUDForum. Page generated in 0.05621 seconds