[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1) Optimize Hibernate for the bulk insertion of related entities

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1?page=comm... ] Martin Ross commented on HHH-1: ------------------------------- We have something that works (for our moderately) complex object. I will submit patch files against the 3.2 branch. We are seeing real world increases of several hundred percent performance on our system. Please test and give feedback. Since hibernate batching occurs using PreparedStatement it appears that you need to do a few things to get the MySQL driver to actual even use batching. A) Use the 5.0.4 connector. The later versions of the 3.1.x series might work. B) Set useServerPrepStmts=false . MySQL server side prepared statements can't batch yet. C) Set rewriteBatchedStatements=true . This is the import part. Also we have discovered some bugs with MySQL and batch inserts. I have filed two issues on MySQL bugs site http://bugs.mysql.com/bug.php?id=25025 and http://bugs.mysql.com/bug.php?id=25047 . Until these are fixed you will A) Need to make sure that hibernate show_sql property is off B) the "insert (..) values (?,?,....)" insert statements generated by hibernate MUST be uppercased. You may need to hack the driver. Or just hack the MySQL connector -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira