更新时间:2023-08-25 23:17:58
https://dev.mysql.com/doc/refman/8.0/en/insert-optimization.html
插入一行所需的时间由以下因素决定,其中数字表示大致比例:
The time required for inserting a row is determined by the following factors, where the numbers indicate approximate proportions:
从这里可以看出,发送一个大语句将为每个插入语句节省 7 的开销,在进一步阅读文本时还说:
From this it should be obvious, that sending one large statement will save you an overhead of 7 per insert statement, which in further reading the text also says:
如果您同时从同一客户端插入多行,请使用带有多个 VALUES 列表的 INSERT 语句一次插入多行.这比使用单独的单行 INSERT 语句快得多(在某些情况下快很多倍).
If you are inserting many rows from the same client at the same time, use INSERT statements with multiple VALUES lists to insert several rows at a time. This is considerably faster (many times faster in some cases) than using separate single-row INSERT statements.