|
Trying to persist ~100MB to a BLOB takes over 1 minute using hibernate 4.2.15.Final in the environment ojdbc6, Oracle DB 11.2.0.3.0, jboss-eap-6.2.
The same test case run with hibernate 3.6.6 takes around 20 sec (ojdbc6, Oracle DB 11.2.0.3.0, jboss-as-6.1.0).
I have enabled the TRACE logging level to see where the time is being consumed and found the following: This takes 25 seconds: "TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [2] as [BLOB] - oracle.sql.BLOB@7017ec1d"
and this takes 30 seconds: "11:17:35,756 DEBUG [org.hibernate.engine.jdbc.batch.internal.BatchingBatch] Executing batch size: 1"
I have attached the persistence.xml file used, the ds description, the java source code that creates and persists the BLOB and the complete logs for hibernate.
I'm wondering if there is something flagrantly wrong with the way I'm creating and persisting the BLOB or something is misconfigured as I doubt that older versions of hibernate would perform better.
I've come across this hibernate behavior when we have migrated our application to JBoss 7.1/JBoss 6.2 eap from JBoss AS 6.1.0.
|