提高DB2 Web程序性能2条规则

using System;

namespace Effeciency
{
///
/// 这个类用于时间计算。在例子中，
/// 我们将利用它检测数据库操作的速度，
/// 以便作性能上的比较。
///
public class TimeDiff
{
DateTime StartTime;
DateTime EndTime;

public TimeDiff() {}

public void Start()
{
StartTime = DateTime.Now;
}

public void Stop()
{
EndTime = DateTime.Now;
}

public string TimeDifferenceText
{
get
{
TimeSpan TimeDifference = EndTime - StartTime;
return TimeDifference.ToString();
}
}
}
}

程序清单2. LOTSOFRECORDS的表定义

CREATE TABLE "GLENN "."LOTSOFRECORDS" (
"KEYCOL" INTEGER NOT NULL ,
"COL1" CHAR(50) ,
"COL2" CHAR(50) ,
"COL3" CHAR(50) ,
"COL4" CHAR(50) ,
"COL5" CHAR(50) ,
"COL6" CHAR(50) ,
"COL7" CHAR(50) ,
"COL8" CHAR(50) ,
"COL9" CHAR(50) ,
"COL10" CHAR(50) )
IN "USERSPACE1" ;
COMMENT ON TABLE "GLENN "."LOTSOFRECORDS" IS 'Table designed to Contain Lots of Records';

-- DDL Statements for primary key on Table "GLENN "."LOTSOFRECORDS"

ALTER TABLE "GLENN "."LOTSOFRECORDS"
ADD CONSTRAINT "CC1058255334652" PRIMARY KEY
("KEYCOL");