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?...
![]() |
| | LinkBack | Thread Tools |
|
#1
| |||
| |||
| 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? |
![]() |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| |
| ||||
| 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.



