c#测试本机sql运算速度的代码示例分享

namespaceConsoleApplication2
{
   classProgram
   {
       staticvoidMain(string[]args)
       {
           SqlConnectionconn=newSqlConnection();
           SqlCommandcomm=newSqlCommand();
           DateTimet1,t2;
           intcount=10000; //循环次数
           stringtimes;
           conn.ConnectionString="DataSource=.;InitialCatalog=Server;IntegratedSecurity=True";
           comm.CommandText="insertintotest(Cid,Cvalue)values("1","1")";//数据插入
           comm.Connection=conn;
           Console.WriteLine("开始插入数据\r\n开始时间:"+(t1=DateTime.Now).ToLongTimeString());
           try
           {
               conn.Open();
               for(inti=1;i<=count;i++)
               {
                   comm.ExecuteNonQuery();//执行查询
               }
               Console.WriteLine("结束时间:"+(t2=DateTime.Now).ToLongTimeString());
               times=GetTimeSpan(t1,t2).ToString();
               Console.WriteLine("持续时间:"+times.Substring(0,times.LastIndexOf(".")+4));
               Console.WriteLine("本次测试总共对数据库进行了"+count+"次数据插入操作！");
               //comm.CommandText="deletefromtest";
               //comm.ExecuteNonQuery();
               //Console.WriteLine("测试数据已删除");
           }
           catch(Exceptionerr)
           {
               Console.WriteLine(err.Message);
           }
           finally
           {
               comm=null;
               conn.Close();
               conn.Close();
           }
           Console.ReadKey();
       }

       ///<summary>
       ///返回两个时间对象的时间间隔
       ///</summary>
       privatestaticTimeSpanGetTimeSpan(DateTimet1,DateTimet2)
       {
           DateTimet3;
           if(DateTime.Compare(t1,t2)==1)
           {
               t3=t1;
               t1=t2;
               t2=t3;
           }
           returnt2.Subtract(t1);
       }
   }
}