关于sqlsugar批量插入海量数据的效率问题 返回
这两天用这个框架试测试插入了1000条数据,看到网上有测试只要1秒左右就行了,为什么我测试了要24秒左右呢。难道是我写的不对吗?求指教,24秒有点慢了,下面是我代码,求指导
List<OrderHeaderTemp> list = new List<OrderHeaderTemp>();
for (int i = 0, h = 1000; i < h; i++)
{
OrderHeaderTemp order = new OrderHeaderTemp();
order.orderId = Guid.NewGuid().ToString();
order.buyerAddress = "cee";
order.buyerName = "3223";
order.buyerPhone = "2323";
order.ecName = "3223";
order.esDate = "3223";
order.orderQuantity = "3";
order.orderStatus = "1";
order.remark = "dasdfsdf";
order.subdist = "323";
list.Add(order);
}
using (SqlSugarClient db = SugarDao.GetInstance())
{
Stopwatch sw = new Stopwatch();
sw.Start();
bool b = db.SqlBulkCopy(list);
sw.Stop();
TimeSpan ts2 = sw.Elapsed;
MessageBox.Show(string.Format("Stopwatch总共花费{0}ms.", ts2.TotalSeconds));
}
热忱回答(1)
-
小杰 VIP0
2017/4/4在慢的机器也没有出现过你这种情况,你可以换成其它方式插入比较一下
0 回复