File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Performance using excuetebatch
Joined: Jan 08, 2010
Jul 31, 2012 22:14:48
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.
Joined: Sep 21, 2006
Aug 01, 2012 07:22:50
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
Loading an image
unable to internalize message
Comments on Jetspeed, Slide, Velocity, Turbine ?
file access within package
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014