JDBC Fetch size

[t16]

Does this have any effect on 4.2.4 with MS SQL DB?

On our production system we have an oracle DB with hibernate.jdbc.fetch_size=150 (v4.2.3), and I wondered if this would have a beneficial impact on our 4.2.4 setup…

Again, I cannot find anything online about the jdbc.fetch_size for MS SQL !


I extend my gratitude to the experts once again, keep up the great work.

[mrogers]

http://webmoli.com/2009/02/01/jdbc-performance-tuning-with-optimal-fetch-size/

The article above says no impact for MS SQL Server.     That parameter seems to be important for ORACLE database only.

[t16]

Thank you so much for your help Mrogers, its really appreciated.