bulk insert using hibernate and sql server

Question

I am using hibernate(3.3 vesion) with sql server 2005. I have to insert 100 thousands records in to database. Since I am using IDENTITY for primary generation strategy, I am not able do bulk insert in hibernate. I tried StatelessSession and couldn't gain any performance.

Could anyone please suggest a way to improve performance?

Please help.

NPKR · Accepted Answer · 2012-12-24 15:46:26Z

1

Use HibernateTemplate.saveOrUpdateAll(Collection entities) will give better performance.

answered Dec 24, 2012 at 15:46

NPKR

5,5165 gold badges35 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Olaf · Accepted Answer · 2012-12-24 18:16:14Z

0

Your main issue here is to prevent Hibernate from caching in memory all the records you are going to insert. If you only bulk insert records in your transaction, you can use StatelessSession. If you do other operations, for example record some statistics about the bulk load, you should call session.flush(), session.clear() after certain number of records, for example, every 10K records.

answered Dec 24, 2012 at 18:16

Olaf

6,2991 gold badge21 silver badges38 bronze badges

Collectives™ on Stack Overflow

bulk insert using hibernate and sql server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related