MySQL Forums
Forum List  »  MySQL Workbench

Slow Data Import Wizard
Posted by: Asher Shanabrook
Date: December 11, 2020 10:19AM


I am experiencing incredibly slow download speeds when I import csv files using the Import Wizard.

First I create an empty table with an auto incremental ID as the primary key, and the only index. I always make sure my csv files already have an ID column as a surrogate ID. However, the import is only one record at a time, with each row taking up to 1.5 seconds. Many of the files I am working with at least in the tens of thousands of records, so this is untenable.

Does anyone have any idea how to get imports to go faster, or at least not one record at a time?

Thank you!

Options: ReplyQuote

Written By
Slow Data Import Wizard
December 11, 2020 10:19AM
December 15, 2020 11:27AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.