关于sqlsugar批量插入海量数据的效率问题 返回

SqlSugar 老数据
1 11141
该叫什么 zoe 发布于2017/4/2
悬赏:5 飞吻

这两天用这个框架试测试插入了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 回复