缓存的运用

using System.Diagnostics;
using System.Data;
using System.Data.SqlClient;

public partial class Default3 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
 protected void Button1_Click(object sender, EventArgs e)
 {
 //using System.Diagnostics
 Stopwatch sw = new Stopwatch();
 sw.Start();
 for (int i = 0; i < 100; i++)
 {
 Response.Write(i.ToString()+" ");
 }
 Response.Write("--------------------------------------------");
 Response.Write(sw.ElapsedTicks);
 }

    public DataSet Dbind()
    {
        DataSet ds = new DataSet();
        using (SqlConnection con = new SqlConnection("server=.;database=a;uid=sa;pwd=123456"))
        {
            con.Open();
            using (SqlDataAdapter cmd = new SqlDataAdapter("select * from a", con))
            {
                cmd.Fill(ds);
            }
        }
        return ds;
    }

//从数据库读出来
 protected void Button3_Click(object sender, EventArgs e)
 {
 Stopwatch sw = new Stopwatch();
 sw.Start();
 DataSet ds= Dbind();
 Response.Write(string.Format("查询结果：{0} ", ds.Tables[0].Rows[300000][0]));
 Response.Write(string.Format("耗费时间：{0} ", sw.ElapsedTicks)); //时间 10978159

}

//从缓存读出来
 protected void Button4_Click(object sender, EventArgs e)
 {
 DataSet ds;
 Stopwatch sw = new Stopwatch();
 sw.Start();
 if (Cache["Data"] != null)
 {
 ds = Cache["Data"] as DataSet;
 }
 else
 {
 ds = Dbind();
 }
 Response.Write(string.Format("查询结果：{0} ", ds.Tables[0].Rows[300000][0]));
 Response.Write(string.Format("耗费时间：{0} ", sw.ElapsedTicks)); //时间 60
 }

    //写入缓存
    protected void Button2_Click(object sender, EventArgs e)
    {
        DataSet ds = Dbind();
        Cache.Insert("Data", ds);
    }

    //删除缓存
    protected void Button5_Click(object sender, EventArgs e)
    {
        Cache.Remove("Data");
    }
}

http://www.cnblogs.com/luluping/archive/2009/09/13/1565732.html