MSSQL、ORALCE批量新增，后者太强

MSSQL：131072条数据，7秒。
代码：

CREATE TABLE tempTable(bigint varchar(30),item_name varchar(30)); INSERT INTO tempTable VALUES (1, 'Hammer') DECLARE @counter int;SET @counter = 1 ;WHILE(@counter <= 17) BEGIN         INSERT INTO tempTable (bigint, item_name)                 (SELECT bigint + (SELECT COUNT(*) FROM tempTable), 'Hammer' FROM tempTable)         SET @counter = @counter + 1END SELECT * FROM tempTable --DROP TABLE tempTable

结果：

ORACLE：131072条数据，0.469秒。
代码：

CREATE TABLE tempTable(bigint varchar(30),item_name varchar(30)); INSERT INTO tempTable VALUES (1, 'Hammer') 

CREATE OR REPLACE PROCEDURE testbatch isbegin  for i in 1 .. 17 loop    INSERT INTO tempTable      (bigint, item_name)      (SELECT bigint + (SELECT COUNT(*) FROM tempTable), 'Hammer'         FROM tempTable);  end loop;  commit;end testbatch;

结果：