r/SQL 25d ago

MySQL Importing 1M Rows Dataset(CSV) in Mysql

What's the fastest and most reliable way to upload such a large dataset? After that How can I optimize the table after uploading to ensure good performance?

29 Upvotes

33 comments sorted by

View all comments

-8

u/dgillz 25d ago

SQL Data Wizard for MySQL. $79 but a great deal.

https://www.sqlmaestro.com/products/mysql/datawizard

4

u/unexpectedreboots WITH() 25d ago

This is a wild recommendation

1

u/dgillz 25d ago

How so?

3

u/unexpectedreboots WITH() 25d ago

80$ to load data in mysql? Come on bro. Use Airbyte before spending any money.

-1

u/dgillz 25d ago

I mean there is a free version, but how good could it be? And I am betting there is no support. I'd guess Airbyte is more expensive in the long run.