JDBC prepared statement, batch insert performance improvement

Asked Aug 16 '13 at 20:43

Active Aug 17 '13 at 15:57

Viewed 634 times

I have a huge set of data, and i want to insert them on database at once, i used prepared statement with batch insert but it takes around 15 seconds on pstmt.executeBatch(). I'm looking for best results (around 5 seconds), how could i achieve my goal?

auto commit is disabled.

number of insert statements: 100000 statement.

edited Aug 17 '13 at 15:57

Jeanne Boyarsky

12,156
2
49
59

asked Aug 16 '13 at 20:43

Mazen Khalil

1

What's your batch size? – Kayaman Aug 16 '13 at 20:50
2

What is your database? If MySQL, see http://stackoverflow.com/q/2993251/25122 – RealHowTo Aug 16 '13 at 21:15

JDBC prepared statement, batch insert performance improvement

0 Answers0