watch = new Stopwatch();
watch.Start();
using (SqlConnection conSave = new SqlConnection(Config.WriteConnectString))
{
conSave.Open();
//conSave.CommandTimeout = Config.SqlExpireTime;
System.Data.SqlClient.SqlBulkCopy sqlBC = new System.Data.SqlClient.SqlBulkCopy(conSave);
sqlBC.BatchSize = 100000;
//sqlBC.
sqlBC.BulkCopyTimeout = Config.SqlExpireTime;
sqlBC.DestinationTableName = "dbo.weblog";
sqlBC.ColumnMappings.Add("ref", "ref");
sqlBC.ColumnMappings.Add("refcount", "refcount");
sqlBC.ColumnMappings.Add("sourpv", "sourpv");
sqlBC.WriteToServer(weblog);
}
watch.Stop();
log.Info("PvBulkCopy BulkCopy时间:" + watch.ElapsedMilliseconds);
转载于:https://www.cnblogs.com/chyen/archive/2012/08/03/2621886.html