Of course it will have an impact, and it will cause a simple update when inserting data. The more strings there are, the slower the insertion will be. See the document description Although it can be tempting to create an indexes for every possible column used in a query, unnecessary indexes waste space and waste time for MySQL to determine which indexes to use. Indexes also add to the cost of inserts, updates, and deletes because each index must be updated. You must find the right balance to achieve fast queries using the optimal set of indexes.
Indexes have a great impact on batch insertion of data. The reason is very simple. On the one hand, the index needs to be written at the same time when writing the table. On the other hand, for unique indexes, it is necessary to check whether the data is duplicated.
For large batches of data import, the index is usually removed first, and then the index is rebuilt after the data import is completed.
Of course it will have an impact, and it will cause a simple update when inserting data. The more strings there are, the slower the insertion will be. See the document description
Although it can be tempting to create an indexes for every possible column used in a query,
unnecessary indexes waste space and waste time for MySQL to determine which indexes to use. Indexes also add to the cost of inserts, updates, and deletes because each index must be updated
. You must find the right balance to achieve fast queries using the optimal set of indexes.Indexes have a great impact on batch insertion of data. The reason is very simple. On the one hand, the index needs to be written at the same time when writing the table. On the other hand, for unique indexes, it is necessary to check whether the data is duplicated.
For large batches of data import, the index is usually removed first, and then the index is rebuilt after the data import is completed.