Entity Framework: Improving Performance when inserting a record in a table with many records

Question

I want to insert a single record into a table with 60 columns (some of them are not required) and 2 million records. It takes about 20 seconds.

var package = new Package()
      {
          DestinationCityId = city.Id,
          OriginCityId = RequestDetails.User.Retailer.CityId,
          State = state,
          CreatedOn = RequestDetails.DateTime,
          CreatedByUserId = RequestDetails.User.Id,
          OrderedOn = RequestDetails.DateTime,
          CustomerName = "a",
          CustomerAddress = "a",
          CustomerEmail = "a",
          CustomerPostalCode = "a",
          CustomerLandPhone = "a",
          CustomerCellPhone = "aa",
          CustomerMessage = "a",
          CustomerSubstitute = "a",
          RetailerPackageDiscount = 0,
          Barcode = "2",
          InternalBarcode = "11111",
          PackagingWeight = 10,
          DeliveryType = PackageDeliveryType.ByPostExpress,
          ProvidedByWarehouse = false,
          NeedReview = false,
          NeedReviewType = NeedReviewType.Unknown,
          RetailerId = retailer.Id,
          Retailer = retailer
      };

DbContext.ZPackages.Add(package);
DbContext.SaveChanges();

Any Idea to improve performance?

Krivitskiy Grigoriy · Accepted Answer · 2020-02-19 08:29:10Z

2

Partitions, Indexes, Async CRUD operations where it possible. This is not EF problem

answered Feb 19, 2020 at 8:29

Krivitskiy Grigoriy

4062 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

keitn · Accepted Answer · 2020-02-19 08:33:36Z

-1

You could also have a look at the EfCore Bulk Extensions project if you're using EF Core https://github.com/borisdj/EFCore.BulkExtensions

answered Feb 19, 2020 at 8:33

keitn

1,2982 gold badges21 silver badges45 bronze badges

1 Comment

johey Over a year ago

This isn't going to help: the OP is just inserting one record.

Collectives™ on Stack Overflow

Entity Framework: Improving Performance when inserting a record in a table with many records

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related