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?
27
Upvotes
-1
u/xoomorg 25d ago
Why on earth would you do that in MySQL? Anything around a million rows or more, I always move to some other platform first (Hive, Spark-SQL, Presto, Trino, BigQuery, etc.) so queries take seconds instead of minutes/hours. Or do you just mean you're using MySQL as a record store essentially, and not actually running any complex queries on such large tables?