jdbc batchsize

LocalSessionFactoryBean.getConfiguration().buildSe ttings().getJdbcBatchSize()


http://www.springframework.org/docs/api/org/springframework/orm/hibernate3/LocalSessionFactoryBean.html#getConfiguration()
http://www.hibernate.org/hib_docs/v3/api/org/hibernate/cfg/Configuration.html#buildSettings()
http://www.hibernate.org/hib_docs/v3/api/org/hibernate/cfg/Settings.html#getJdbcBatchSize()


如果过大，优点是插入的语句次数小，但缺点是每次事务提交的数据量大，内存占用也厉害。
如果过小，优缺点刚好相反，所以不能笼统的说设置的值越大或者越小就越好，需要测试过，跟进实践情况而定。


https://www.hibernate.org/117.html#A21

I am experiencing slow performance or low memory when inserting or querying 10000 objects
In Hibernate 3.0 or earlier you must manage the size of the session cache using clear() or evict(). See also:

http://www.hibernate.org/hib_docs/v3/reference/en/html/batch.html

In Hibernate 3.1, you can use StatelessSession.

Even better, try to use HQL bulk queries where possible.

Batching and auto-evicting Criteria results
https://www.hibernate.org/442.html