62,067
社区成员
发帖
与我相关
我的任务
分享
DateTime begin = DateTime.Now;
string connectionString = "...";
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlDataAdapter sd = new SqlDataAdapter();
sd.SelectCommand = new SqlCommand("select devid,data_time,data_value from CurrentTest", conn);
sd.InsertCommand = new SqlCommand("insert into CurrentTest(devid,data_time,data_value) "
+ " values (@devid,@data_time,@data_value);", conn);
sd.InsertCommand.Parameters.Add("@devid", SqlDbType.Char, 18, "devid");
sd.InsertCommand.Parameters.Add("@data_time", SqlDbType.Char, 19, "data_time");
sd.InsertCommand.Parameters.Add("@data_value", SqlDbType.Int, 8, "data_value");
sd.InsertCommand.UpdatedRowSource = UpdateRowSource.None;
sd.UpdateBatchSize = 0;
DataTable dt = new DataTable();
sd.Fill(dt);
Random r = new Random(1000);
for (int i = 0; i < 100000; i++)
{
object[] row = { "DEVID" + i, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), r.Next(1, 1000) };
dt.Rows.Add(row);
if (i % 300 == 0)
{
sd.Update(dt);
dt.Clear();
}
}
sd.Update(dt);
dt.Clear();
sd.Dispose();
dt.Dispose();
conn.Close();
}
TimeSpan ts = DateTime.Now - begin;
Response.Write("ts = " + ts.TotalMilliseconds);