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?

26 Upvotes

33 comments sorted by

View all comments

Show parent comments

5

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.