Hi,

To improve performance, I added DB_CLOSE_DELAY=-1 to the connection
> string, but shown no real benefit.


That's strange, because according to my tests it does improve performance,
about the same amount as keeping a connection open (not quite, but close
enough).

Could you post a test case? My test case:
http://h2database.com/p.html#540deb9480ac2b16a445fdaef543ab60

Results (first column is time in millis to open/close 5000 connections):
1555 jdbc:h2:mem:test
192 jdbc:h2:mem:test;db_close_delay=-1
149 jdbc:h2:mem:test using sentinel connection
191 jdbc:h2:mem:test;db_close_delay=-1 using sentinel connection

Regards,
Thomas

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to