文件名称:Sql2000_test
- 所属分类：
- SQL Server数据库
- 资源属性：
- [Dephi] [Pascal] [源码]
- 上传时间：
- 2012-11-26
- 文件大小：
- 5kb
- 下载次数：
- 0次
- 提 供 者：
- 齐**
- 相关连接：
- 无
- 下载说明：
- 别用迅雷下载，失败请重下，重下不扣分！
介绍说明－－下载内容均来自于网络，请自行研究使用
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 scr ipt. 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
数据库请自己建，附脚本。不懂的可以发邮件问我：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 scr ipt. 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
(系统自动生成,下载前可以参看下载内容)
下载文件列表
数据库大容量数据测试
....................\1.sql
....................\log.txt
....................\Project_SQLServer_Test.dpr
....................\Project_SQLServer_Test.res
....................\Unit_main.dfm
....................\Unit_main.pas
....................\1.sql
....................\log.txt
....................\Project_SQLServer_Test.dpr
....................\Project_SQLServer_Test.res
....................\Unit_main.dfm
....................\Unit_main.pas