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
FetchSize / Array Size
Re: FetchSize / Array Size
excuse me, of course I meant TOraQuery.FetchRows...Schmidtze wrote:Is perhaps the property TOraQuery.FetchAll the equivalent property which has to be used?
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.
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.