Conclusion and recommendations for JDBC Fetch Size

Description of your first forum.
Post Reply
Mitu9900
Posts: 224
Joined: Thu Dec 26, 2024 9:18 am

Conclusion and recommendations for JDBC Fetch Size

Post by Mitu9900 »

Based on the experiment, we can confirm that the new memory management strategy in the 12c driver definitely opens up new opportunities for performance improvement. Nevertheless, there are a few things to keep in mind:

There is no point in configuring bulgaria telegram screening unnecessarily high values. Statements that return no more than n records do not benefit from a fetch size > n.
Excessive fetch sizes can result in unnecessary memory overhead (although with much less impact than the 11g driver).
It may be useful to configure different fetch sizes for different statements.

If an application "scrolls" through the result set anyway, i.e. only displays n records at a time, a fetch size > n is pointless.
Here, throughput was considered as a criterion for performance. Depending on the application, it is advisable to also test the latency (response time / latency).
Post Reply