Objectmix
Tags Register Mark Forums Read

Jdbc inserts are very slow : JDBC JAVA

This is a discussion on Jdbc inserts are very slow within the JDBC JAVA forums in Framework and Interface Programming category; hello, I'm having a performance issue with mysql. My code is performing 15000 inserts to the db. I'm using preparedStatment and addBatch and executeBatch, I've tried many batch sizes, but nothing helps. for 100 batch size it takes 35 seconds! When I make the batch size bigger, I get no performance increase. How can I make this code perform better?...


Object Mix > Framework and Interface Programming > JDBC JAVA > Jdbc inserts are very slow

Reply

 

LinkBack Thread Tools
  #1  
Old 03-07-2010, 09:23 AM
Junior Member
 
Join Date: Mar 2010
Posts: 1
ran_inc is on a distinguished road
Default Jdbc inserts are very slow

hello,
I'm having a performance issue with mysql.
My code is performing 15000 inserts to the db.
I'm using preparedStatment and addBatch and executeBatch,
I've tried many batch sizes, but nothing helps.
for 100 batch size it takes 35 seconds!
When I make the batch size bigger, I get no performance increase.

How can I make this code perform better?
Reply

Thread Tools


Similar Threads

Thread Thread Starter Forum Replies Last Post
Slow performance WLS with jdbc pools usenet Weblogic 2 11-02-2006 03:49 AM
Jdbc Oracle getMetaData is slow? usenet JDBC JAVA 2 03-29-2006 01:39 AM
DB2 JDBC addBatch truncates DECIMAL fields during inserts, if the last row has null values usenet JDBC JAVA 0 12-21-2005 11:19 AM
Slow return on JDBC call from WebLogic usenet Weblogic 3 01-20-2004 01:46 PM


All times are GMT -5. The time now is 12:40 AM.

Managed by Infnx Pvt Ltd.