/// <summary> /// 批量插入测试 /// 方法1耗时16秒以上 /// 方法2耗时22秒以上 /// </summary> /// <returns></returns> public ActionResult Index() { var sw = new Stopwatch(); var sw2 = new Stopwatch(); #region 构造数据 var random = new Random(); var list = new List <Coupon>(); for (var i = 0; i < 1000; i++) { list.Add(new Coupon { Number = DateTime.Now.ToString("HHmmss") + random.Next(10000000, 100000000), Price = 10, Status = EnumCouponStatus.Actived, CouponCategoryId = 1 }); } #endregion sw.Start(); _couponService.BulkCreate(list); sw.Stop(); sw2.Start(); foreach (var p in list) { _couponService.Create(p); } sw2.Stop(); @ViewBag.t1 = sw.ElapsedMilliseconds.ToString(CultureInfo.InvariantCulture); @ViewBag.t2 = sw2.ElapsedMilliseconds.ToString(CultureInfo.InvariantCulture); return(View()); }
public HttpResponseMessage BlukCreate(CouponModel model) { Random random = new Random(); List <global::Event.Entity.Entity.Coupon.Coupon> list = new List <global::Event.Entity.Entity.Coupon.Coupon>(); for (int i = 0; i < model.Count; i++) { list.Add(new global::Event.Entity.Entity.Coupon.Coupon { Number = DateTime.Now.ToString("HHmmss") + random.Next(10000000, 100000000), Price = model.Price, Status = model.Status, CouponCategoryId = model.CouponCategoryId }); } if (_couponService.BulkCreate(list)) { return(PageHelper.toJson(PageHelper.ReturnValue(true, "数据添加成功"))); } return(PageHelper.toJson(PageHelper.ReturnValue(false, "数据添加失败"))); }