hibernate mysql 优化_关于hibernate 批量数据插入 mysql批量插入数据优化-问答-阿里云开发者社区-阿里云...

Session session = SessionFactory.openSession();

Transaction tx = session.beginTransaction();

for ( int i=0; i<100000; i++ ) {

Employee employee = new Employee(.....);

session.save(employee);

if( i % 50 == 0 ) { // Same as the JDBC batch size

//flush a batch of inserts and release memory:

session.flush();

session.clear();

}

}

tx.commit();

session.close();

然后还需要在配置文件中配置下hibernate.jdbc.batch_size，它的值与上面的值相等：

/p>

"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

org.hibernate.dialect.MySQLDialect

com.mysql.jdbc.Driver

jdbc:mysql://localhost/test

root

root123

50