Location:
Search - SQL Stress Tes
Search list
Description: Sqlserver2000压力测试
数据库请自己建，附脚本。不懂的可以发邮件问我：killwolf@163.com
10万
109640ms 插入
23078ms 清空
20万
216281ms
8391马上
40万：
416781
9381
if exists (select * from dbo.sysobjects where id = object_id(N [dbo].[StuInfo] ) and OBJECTPROPERTY(id, N IsUserTable ) = 1)
drop table [dbo].[StuInfo]
GO
CREATE TABLE [dbo].[StuInfo] (
[StuID] [float] NULL
) ON [PRIMARY]
GO-Stress-testing SQL Server 2000 database to build your own, with a script. Do not understand the question I can e-mail: killwolf@163.com10 million 109640ms insert 23078ms empty 200,000 216281ms8391 immediately 400000: 4167819381if exists (select* from dbo.sysobjects where id = object_id (N [dbo]. [StuInfo]) and OBJECTPROPERTY (id, N IsUserTable) = 1) drop table [dbo]. [StuInfo] GOCREATE TABLE [dbo]. [StuInfo] ([StuID] [float] NULL) ON [PRIMARY] GO
Platform: |
Size: 5120 |
Author: 齐欢乐 |
Hits: