-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: Batch insert shows insert for each entity
PostPosted: Mon May 19, 2008 11:06 am 
Newbie

Joined: Fri Jun 11, 2004 8:41 am
Posts: 6
Location: Belgium
Hibernate version:
3.3.0.CR1

Name and version of the database you are using:
MySQL 5

I just wanted to let this know to other users because I've spent almost a week searching the forums and the Internet why I kept seeing an insert statement (hibernate.show_sql=true) for each entity insert even after I specified to use batch inserts (hibernate.jdbc.batch_size=50).

I changed to hilo id generator instead of autoincrement and I changed the timestamp columns to datetime types.

Only when using p6spy I discovered that although the Hibernate SQL shows an insert for each entity, they are still sent to the database in a batch.

So I should have trusted Hibernate to do the right thing from the beginning!


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.