Hibernate version:

2.1.8

Hello all,

I have a small question about tweaking Hibernate performance. Common sense would tell me to use the collection pooling and statement caching facilities of the NonStop SQL/MX JDBC/MX driver [1]. However, with JDBC/MX pooling and caching enabled, the execution time of INSERT statement dropped from 400ms to 200ms when I enabled Hibernate's internal connection pooling in addition to driver's pooling.

I don't quite understand how adding a pool on top of pool could increase performance.. any comments or other recommendations how to tweak performance with Hibernate and JDBC drivers?

[1]
http://h30163.www3.hp.com/NTL/view/?id= ... .htm&toc=y