File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
Bookmark "Performance using excuetebatch" Watch "Performance using excuetebatch" New topic
Author

Performance using excuetebatch

anvi kon
Ranch Hand

Joined: Jan 08, 2010
Posts: 133
Hi,

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.


Thanks,
Bill Clar
Ranch Hand

Joined: Sep 21, 2006
Posts: 153

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