MS SQL性能测试

最新推荐文章于 2025-05-12 14:47:23 发布

jianwangwuwo5

最新推荐文章于 2025-05-12 14:47:23 发布

阅读量384

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签：性能测试 ms sql

本文链接：https://blog.csdn.net/jianwangwuwo5/article/details/53573861

数据库专栏收录该内容

3 篇文章

订阅专栏

MS SQL插入：

SET IMPLICIT_TRANSACTIONS ON

DECLARE @I INTEGER, @STARTTIME DATETIME, @ENDTIME DATETIME, @SUM INT


DELETE FROM PERSON;
COMMIT TRAN;

SET @SUM = 100000
SET @STARTTIME = GETDATE();
SET @I = 0;
WHILE @I < @SUM
BEGIN
  INSERT INTO PERSON VALUES('JW');
  SET @I = @I + 1;
END
COMMIT TRAN;

SET @ENDTIME = GETDATE();
SELECT @ENDTIME - @STARTTIME;


DELETE FROM PERSON;
COMMIT TRAN;

SET @STARTTIME = GETDATE();
SET @I = 0;
WHILE @I < @SUM
BEGIN
  INSERT INTO PERSON VALUES('JW');
  SET @I = @I + 1;
END
COMMIT TRAN;

SET @ENDTIME = GETDATE();
SELECT @ENDTIME - @STARTTIME;


DELETE FROM PERSON;
COMMIT TRAN;

SET @STARTTIME = GETDATE();
SET @I = 0;
WHILE @I < @SUM
BEGIN
  INSERT INTO PERSON VALUES('JW');
  SET @I = @I + 1;
END
COMMIT TRAN;

SET @ENDTIME = GETDATE();
SELECT @ENDTIME - @STARTTIME;


DELETE FROM PERSON;
COMMIT TRAN;

SET @STARTTIME = GETDATE();
SET @I = 0;
WHILE @I < @SUM
BEGIN
  INSERT INTO PERSON VALUES('JW');
  COMMIT TRAN;
  SET @I = @I + 1;
END

SET @ENDTIME = GETDATE();
SELECT @ENDTIME - @STARTTIME;


DELETE FROM PERSON;
COMMIT TRAN;

SET @STARTTIME = GETDATE();
SET @I = 0;
WHILE @I < @SUM
BEGIN
  INSERT INTO PERSON VALUES('JW');
  COMMIT TRAN;
  SET @I = @I + 1;
END

SET @ENDTIME = GETDATE();
SELECT @ENDTIME - @STARTTIME;


DELETE FROM PERSON;
COMMIT TRAN;

SET @STARTTIME = GETDATE();
SET @I = 0;
WHILE @I < @SUM
BEGIN
  INSERT INTO PERSON VALUES('JW');
  COMMIT TRAN;
  SET @I = @I + 1;
END

SET @ENDTIME = GETDATE();
SELECT @ENDTIME - @STARTTIME;