-->
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.  [ 2 posts ] 
Author Message
 Post subject: Inserting multiple records
PostPosted: Mon May 30, 2005 7:47 am 
Expert
Expert

Joined: Thu May 26, 2005 9:19 am
Posts: 262
Location: Oak Creek, WI
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.0.5

Name and version of the database you are using:
PostgreSQL8

Hi

I have User Interface with a bunch of controls and based of user data, I can end up inserting as many as 60 records in a database table. So for instance a user provides me with a bunch of input data and clicks in save button, and I will have 60 records to insert.

I am currently executing an insert command for each row in a for loop. Is there any way I can do a bulk insert. Current process takes a few seconds to execute and I see a performance issue here. Please advice how can I improve the performance using Hibernate.

Waiting for ur reply

Regards
RamnathN


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 18, 2005 7:04 am 
Newbie

Joined: Thu Feb 03, 2005 5:49 am
Posts: 19
Have you read about Batch Insert?
I think it would be usefull

http://www.hibernate.org/hib_docs/v3/re ... mance.html?


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

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.