我试图了解类似之间的性能差异
INSERT INTO Person (id, name) VALUES
(1, "Kevin"),
(2, "John"),
(3, "Jane"),
...
和
BEGIN TRANSACTION;
INSERT INTO Person (id, name) VALUES (1, "Kevin");
INSERT INTO Person (id, name) VALUES (2, "John");
INSERT INTO Person (id, name) VALUES (3, "Jane");
...
END TRANSACTION;
我知道在交易期间索引是临时建立的,但我不太确定。我也不知道两者之间的其他性能差异。