This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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