测试环境
测试代码
create table Product(
SysNo int identity(1,1),
ProductName nvarchar(200),
Category int
)
go
declare @Num int =0
while @Num < 100000
begin
set @Num = @Num + 1
insert into product (ProductName,Category) values ( 'Product'+ cast(@Num as varchar),1)
end
结果截图
固态硬盘 100000/11 = 9090 row/s
机械硬盘(5400转) 100000/29 = 3448 row/s