File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 163

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
It's not a secret anymore!