Devart Forums

Hello,

we are using ODAC 6.7.

Is there perhaps the possibility to set array size or FetchSize somewhere in the components, maybe on TOraSession or on TOraQuery as mentioned here in this article: REDUCING ORACLE NETWORK CONTENTION

Is perhaps the property TOraQuery.FetchAll the equivalent property which has to be used?

Many thanks in advance and best regards
Friedemann

Schmidtze wrote:Is perhaps the property TOraQuery.FetchAll the equivalent property which has to be used?

excuse me, of course I meant TOraQuery.FetchRows...

Best regards
Friedemann

Hello,

When changing the TOraQuery.FetchRows property value, you will get the behaviour similar to the one described by you in the article, i.e. when increasing this property, the package size is increased as well, that allows to improve the performance. However, you should take into account that performance depends not only on the size of the transferred packages, but on network throughput capacity as well, therefore to get the optimal performance, you should experimentally determine the values of the TOraQuery.FetchRows property.

Wow, what a quick response! Thank you very much!

Best regards
Friedemann

Hello,

If you have any other questions, feel free to contact us.