Improving bulk insert performance in Entity framework [duplicate]

by

There is opportunity for several improvements (if you are using DbContext):

Set:

yourContext.Configuration.AutoDetectChangesEnabled = false;
yourContext.Configuration.ValidateOnSaveEnabled = false;

Do SaveChanges() in packages of 100 inserts… or you can try with packages of 1000 items and see the changes in performance.

Since during all this inserts, the context is the same and it is getting bigger, you can rebuild your context object every 1000 inserts. var yourContext = new YourContext(); I think this is the big gain.

Doing this improvements in an importing data process of mine, took it from 7 minutes to 6 seconds.

The actual numbers… could not be 100 or 1000 in your case… try it and tweak it.

More Related Contents:

  1. How can I disable migration in Entity Framework 6.0
  2. what is difference between a Model and an Entity
  3. check constraint entity framework
  4. How to delete an object by id with entity framework
  5. EF Core Second level ThenInclude missworks
  6. The relationship could not be changed because one or more of the foreign-key properties is non-nullable
  7. Convert value when mapping
  8. ADO.NET DbContext Generator vs. ADO.NET Poco Entity Generator (ObjectContext)
  9. Entity Framework code first unique column
  10. How to include a child object’s child object in Entity Framework 5
  11. Entity framework code-first null foreign key
  12. Entity Framework 4.2 exec sp_executesql does not use indexes (parameter sniffing)
  13. Multi-async in Entity Framework 6?
  14. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  15. ef core 2 apply HasQueryFilter for all entity
  16. Value cannot be null. Parameter name: entitySet
  17. SQL Server Express connection string for Entity Framework Code First
  18. Entity Framework Code First – Advantages and disadvantages of Fluent Api vs Data Annotations [closed]
  19. EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]
  20. EF Code First DBContext and Transactions
  21. Error 6002: The table/view does not have a primary key defined
  22. How do I use Entity Framework in Code First Drop-Create mode?
  23. Many to Many Relationships not saving
  24. How do I remove underscore of foreign key fields in code first by convention
  25. Entity Framework Validation confusion – maximum string length of ‘128’
  26. Number of members in conceptual type does not match with number of members on object side type
  27. Delete an object and all of its related entities in Entity Framework
  28. LINQ To Entities + Include + Anonymous type issue
  29. Entity Framework Core 2.0 – Run migrations step by step
  30. EF4 LINQ Ordering Parent and all child collections with Eager Loading (.Include())

Leave a Comment