Dec 15
MySQL 5.0
mysql-connector-java-5.0.4-bin.jar
166 Mb dump file with 1 704 067 rows
|
Method
|
Time
|
|
Strait insert, one row at a time
|
6:15 min
|
|
Same insert but with prepared statement
|
6:42 min
|
|
Batched insert (10 at a time)
statement.addBatch()
…
statement.executeBatch()
|
6:20 min
|
|
Select into … values (…),(…)….
|
1:56 min
|
|
Bulk insert (100 at a time)
|
1:13 min
|
|
Bulk insert (1000 at a time)
|
1:05 min
|
December 16th, 2006 at 1:38 am
огось, балки в 6 разофф рульнее )..