Improves MySQL insertion Efficiency

A small experience I have summarized previously, if a large number of records are inserted into MySQL at one time:

 

1. Use transaction. Enable a transaction for the insert operation.

 

2. concatenate multiple insert statements into one insert statement. For example:

 

You have two records to insert. One record is inserted as follows:

Insert into XX values (1, 2, 3 );

Insert into XX value (4, 5, 6 );

 

This is usually slow. If you splice it into an SQL statement:

Insert into XX values (, 3), (, 6). In this way, the insertion speed will be significantly improved.

 

Especially for thousands of records, the insertion time is greatly reduced.

 

It is not convenient to paste your own code here. I hope you can try it.