Bug #101803 MySQL Workbench Table Data Import Wizard is still extremely slow
Submitted: 30 Nov 2020 14:13 Modified: 2 Dec 2020 13:19
Reporter: William Karavites Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S5 (Performance)
Version:8.0.21 OS:Windows
Assigned to: CPU Architecture:x86
Tags: Data Import, import, Import Wizard

[30 Nov 2020 14:13] William Karavites
Description:
This may be a duplicate to a closed issue, even though it is still happening.

https://bugs.mysql.com/bug.php?id=95481

Whenever you try and import data into a table using the import Wizard, it is HORRIBLY slow.

I've tried it with all combinations of tables and file-types.

Tables with a few columns, with a large file.
Tables with a few columns, small file
Tables with a large number of columns, small and large.
And a mix of indexes ...etc.

It could take upwards of an hour to import a simple 300MB CSV sometimes to a field with no PK and 9 columns. I'm trying it now and it's taken around 10 minutes to import 40k records.

Please don't ask me to submit sample schema and files as it'll happen with any type of schema and any type of file.

How to repeat:
Attempt to use the Data Import Wizard. You'll see how slow it is.
[2 Dec 2020 12:42] MySQL Verification Team
Hello William Karavites,

Thank you for the bug report.
Verified as described.

Regards,
Ashwini Patil
[2 Dec 2020 13:19] William Karavites
No problem Ashwini. Let me know if you need me to test anything else on my platform.
[24 Mar 2021 13:05] MySQL Verification Team
Bug #103074 marked as duplicate of this one.
[4 Apr 2021 12:20] MySQL Verification Team
https://bugs.mysql.com/bug.php?id=95481 marked as duplicate of this one.
[15 Apr 2022 7:55] MySQL Verification Team
Bug #107028 marked as duplicate of this one
[18 Jan 2023 19:26] Madan Kumar
Importing csv file to the Sql taking too long