Article about ways to optimize INSERT operations and look at alternatives when you need to load more than a few rows in the LOAD DATA INFILE statement.
https://www.red-gate.com/simple-talk/databases/mysql/optimizing-mysql-adding-data-to-tables/
#mysql #performance #insert
https://www.red-gate.com/simple-talk/databases/mysql/optimizing-mysql-adding-data-to-tables/
#mysql #performance #insert
Simple Talk
Optimizing MySQL: Adding Data to Tables - Simple Talk
Welcome back to the MySQL optimization series! In case you haven’t been following this series, in the past couple of articles we have discussed the basics