MS SQL性能测试

来源：互联网发布：java高内聚低耦合编辑：程序博客网时间：2024/06/06 16:37

MS SQL插入：

SET IMPLICIT_TRANSACTIONS ONDECLARE @I INTEGER, @STARTTIME DATETIME, @ENDTIME DATETIME, @SUM INTDELETE FROM PERSON;COMMIT TRAN;SET @SUM = 100000SET @STARTTIME = GETDATE();SET @I = 0;WHILE @I < @SUMBEGIN  INSERT INTO PERSON VALUES('JW');  SET @I = @I + 1;ENDCOMMIT TRAN;SET @ENDTIME = GETDATE();SELECT @ENDTIME - @STARTTIME;DELETE FROM PERSON;COMMIT TRAN;SET @STARTTIME = GETDATE();SET @I = 0;WHILE @I < @SUMBEGIN  INSERT INTO PERSON VALUES('JW');  SET @I = @I + 1;ENDCOMMIT TRAN;SET @ENDTIME = GETDATE();SELECT @ENDTIME - @STARTTIME;DELETE FROM PERSON;COMMIT TRAN;SET @STARTTIME = GETDATE();SET @I = 0;WHILE @I < @SUMBEGIN  INSERT INTO PERSON VALUES('JW');  SET @I = @I + 1;ENDCOMMIT TRAN;SET @ENDTIME = GETDATE();SELECT @ENDTIME - @STARTTIME;DELETE FROM PERSON;COMMIT TRAN;SET @STARTTIME = GETDATE();SET @I = 0;WHILE @I < @SUMBEGIN  INSERT INTO PERSON VALUES('JW');  COMMIT TRAN;  SET @I = @I + 1;ENDSET @ENDTIME = GETDATE();SELECT @ENDTIME - @STARTTIME;DELETE FROM PERSON;COMMIT TRAN;SET @STARTTIME = GETDATE();SET @I = 0;WHILE @I < @SUMBEGIN  INSERT INTO PERSON VALUES('JW');  COMMIT TRAN;  SET @I = @I + 1;ENDSET @ENDTIME = GETDATE();SELECT @ENDTIME - @STARTTIME;DELETE FROM PERSON;COMMIT TRAN;SET @STARTTIME = GETDATE();SET @I = 0;WHILE @I < @SUMBEGIN  INSERT INTO PERSON VALUES('JW');  COMMIT TRAN;  SET @I = @I + 1;ENDSET @ENDTIME = GETDATE();SELECT @ENDTIME - @STARTTIME;

结果1：
这里写图片描述
结果2：

MS SQL查询：

SELECT TOP 100000 * FROM PERSON;

结果1：
这里写图片描述

结果2：
这里写图片描述

0 0