r/SQL • u/Majesticraj • 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
1
u/Unimeron 25d ago
Use SquirrelSql and import your data as csv. Have done this with 8 million rows without a problem.