Bug #103074 Table Import Wizard should use LOAD command internally to speed up data import

• Submitted: 23 Mar 2021 13:25
• Modified: 24 Mar 2021 13:04
• Reporter: Michael Kaufmann
• Status: Duplicate
• Category: MySQL Workbench: Migration
• Severity: S5 (Performance)
• OS: Any
• CPU Architecture: Any

[23 Mar 2021 13:25] Michael Kaufmann

Description:
When I load 500K data records from CSV into a MySQL table, it takes 6 sec. using the LOAD command.

When I load the same records using the Table Data Import Wizard, I would expect that it takes the same amount of time. But it acutally takes 1.5 hours.

How to repeat:
1.  Load  a larger CSV datafile  (30MB+) using LOAD command, measure time
2. Load  the same dataa file using Table Import Wizard, measure time
3. Compare time

Suggested fix:
I guess the Wizard does not use the LOAD command internally, but translates a CSV into a series of INSERT statements. Thus, it takes very long and the import wizard becomes practically unusable for real-world applications.

I work with many students on database projects at my university and this problem occurs often  in class. It would help to use the same functionality as the LOAD command for the data import wizard to speed up the process, or even the one from the parallel load of MySQL shell.

[24 Mar 2021 13:04] MySQL Verification Team

Hello Michael Kaufmann,

Thank you for the bug report.
Imho this is duplicate of Bug #101803, please see Bug #101803.

Regards,
Ashwini Patil