MySQL Bugs: #101803: MySQL Workbench Table Data Import Wizard is still extremely slow

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, 8.0.36	OS:	Windows
Assigned to:		CPU Architecture:	x86
Tags:	Data Import, import, Import Wizard

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.

Hello William Karavites,

Thank you for the bug report.
Verified as described.

Regards,
Ashwini Patil

No problem Ashwini. Let me know if you need me to test anything else on my platform.

Bug #103074 marked as duplicate of this one.

https://bugs.mysql.com/bug.php?id=95481 marked as duplicate of this one.

Bug #107028 marked as duplicate of this one

Importing csv file to the Sql taking too long

Bug #114868 marked as duplicate of this one