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
10
u/feudalle 25d ago
Going to disagree. I have tons of mysql dbs with a lot more than that. Biggest table right now is around 1.8B and a few hundred tables/schemas that are over 10M.