Major performance boost from avoiding integer (and double) conversions from strings.
Major performance boost from new [non-default] connection mode with the autoFinish boolean parameter disabled.
Disabling auto-finish retains open prepared statement handles, which the application is responsible to manage and release before disconnect. For applications that frequently run the same query this can be a significant speedup. Some HDBC functions (queryQuery and quickQuery' are unsafe in this mode and should be avoided).
A mock-up of an an application that repeatedly queries for the same 8 rows 10000 times saw a change in runtime from 13.6 seconds to 5.7 seconds.
Disabling auto-finish retains open prepared statement handles, which the application is responsible to manage and release before disconnect. For applications that frequently run the same query this can be a significant speedup. Some HDBC functions (queryQuery and quickQuery' are unsafe in this mode and should be avoided).
A mock-up of an an application that repeatedly queries for the same 8 rows 10000 times saw a change in runtime from 13.6 seconds to 5.7 seconds.