Sebelum lebaran gw di suruh tes mysql, sanggup ampe gimana tuh… sama tes cara insert mass data ke mysql n’ this is the results :

Using Stored Procedure in MySQL GUI (SQLyog) 100msg/sec
insert 60000 record
start 09:26:59
end 09:54:36
time –> 27:37
max memory usage 1.57gb

Using Stored Procedure in Command Prompt 100msg/sec
insert 60000 record
start 10:11:26
end 10:37:33
time –> 26:07
max memory usage 385mb
Using Load File
Generated 1.000.000 records using script –> BulkLoad.java
Start 09:32:46
End 09:34:09
Elapsed 1 minute 23 seconds
Load file into database (using navicat)
Elapsed 566.688sec or 9 minutes 45 seconds
max memory usage 350mb

Gila, load file tuh cepet banget gak ada duanya… cuma perlu bikin script buat generated load filenya aja (yang bagus tentunya…!)