Is it possible to configure the fetch size (the number of rows to fetch at a time) from the default 10 at a datasource connection?
I am using the newest Oracle JDBC driver and experiencing some performace issues and I was recommended to change this default value of 10.
Thanks,
Tibor Hugyecz
AutSoft Zrt.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The setting is available on a report but not currently available per datasource. I also see that the oracle driver has a defaultRowPrefetch property so perhaps this can be specified in the url.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi!
Is it possible to configure the fetch size (the number of rows to fetch at a time) from the default 10 at a datasource connection?
I am using the newest Oracle JDBC driver and experiencing some performace issues and I was recommended to change this default value of 10.
Thanks,
Tibor Hugyecz
AutSoft Zrt.
The setting is available on a report but not currently available per datasource. I also see that the oracle driver has a defaultRowPrefetch property so perhaps this can be specified in the url.
Thanks. :)
Actually changing the setting report-by-report can be an alternative to what we want to achive. :)
Last edit: Tibor Hugyecz 2020-10-16