The MySQL workbench has a handy tool to import CSV files:
Unfortunately it is extremely slow. Here are some timing figures when compared with the LOAD INFILE command.
Timings are in seconds. Extrapolating this, it would take about 22 hours to import my 1.7 million record CSV file using the Import Wizard. I suspect this method will commit after every row, which is often a performance killer. So better use the LOAD INFILE command:
PS. Be aware that using the import wizard, the cancel button does not work during the import:
No comments:
Post a Comment