Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 150

You could try breaking it into small batches of 10000 records and use a loop.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Performance using excuetebatch
 
Similar Threads
Comments on Jetspeed, Slide, Velocity, Turbine ?
unable to internalize message
how to
Loading an image
file access within package