Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Performance using excuetebatch

 
anvi kon
Ranch Hand
Posts: 133
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 163
Eclipse IDE Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You could try breaking it into small batches of 10000 records and use a loop.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic