rocket mass heater kickstarter
The moose likes JDBC and Relational Databases and the fly likes Performance using excuetebatch Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Performance using excuetebatch" Watch "Performance using excuetebatch" New topic

Performance using excuetebatch

anvi kon
Ranch Hand

Joined: Jan 08, 2010
Posts: 133

I am using excuetebatch of prepared statement to insert 600000 records into the Mysql database, but it is taking long time to process.Is there any way to make the process fast.

Bill Clar
Ranch Hand

Joined: Sep 21, 2006
Posts: 159

You could try breaking it into small batches of 10000 records and use a loop.
I agree. Here's the link:
subject: Performance using excuetebatch