Articles

Add Performance

Improve EF Add Performance...How to Improve Entity Framework Add Performance?...When you overuse the Add() method for multiple entities, your application suffers from performance issues....using (var ctx = new CustomerContext()) { foreach(var line in lines) { var customer = new Customer(); // ...code... ctx.Customers.Add(customer); } ctx.SaveChanges(); } ...StackOverflow Related Questions...WebAPI EF update 30,000 rows of data is very slow...Performan...

Detect Changes Performance

Improve EF DetectChanges Performance...How to Improve Entity Framework DetectChanges Performance?...When you track multiple entities in your context, then your application will suffer from performance issues causing by Entity Framework DetectChanges method....using (var ctx = new CustomerContext()) { foreach(var line in lines) { var customer = new Customer(); // ...code... // DetectChanges is invoked every time you call Add ctx.Customers.Add(custo...

EF Performance

Improve Entity Framework Performance...Improve Entity Framework Performance...Is Entity Framework as slow as some people report it? Yes and no....Entity Framework offers great advantages over other ORM, and it's in fact pretty fast....Problem...It's too easy to fall into a Entity Framework performance pitfall....Sooner or later, many developers make some mistakes which may impact the application performance severely....Performance Cheat Sheet...Problem...Solution...Add...Use AddRange...Disable A...

Include Performance

Improve EF Include Performance...How to Improve Entity Framework Include Performance?...Entity Framework does a great job to generate SQL. However, they are often very far to be optimized....using (var ctx = new CustomerContext()) { var customers = ctx.Customers .Include(x => x.Orders.Select(y => y.Items.Select(z => z.Product)) .Include(x => x.Payments.Select(y => y.Items) .Include(x => x.Shippings.Select(y => y.Items) .ToList(); } ...StackOverflow Related Que...

Insert Performance

Improve EF Insert Performance...How to Improve Entity Framework Insert Performance?...When you want to insert hundreds, thousands, or millions of entities, and your application suffers from performances issues....using (var ctx = new CustomerContext()) { List<Customer> customers = new List<Customer>(); foreach(var line in lines) { var customer = new Customer(); // ...code... customers.Add(customer); } ctx.Customers.AddRange(customers...

Save Changes Performance

Improve EF SaveChanges Performance...How to Improve SaveChanges Performance?...The DbContext.SaveChanges is a poor choice for BULK operations as far as performance is concerned. Once you get beyond a few thousand records, the SaveChanges method really starts to break down....using (var ctx = new CustomerContext()) { List<Customer> customers = new List<Customer>(); foreach(var line in lines) { var customer = new Customer(); // ...code... customers...

Save Changes Performance

SaveChanges Performance...How to Improve SaveChanges Performance?...The DbContext.SaveChanges is a poor choice for BULK operations as far as performance is concerned. Once you get beyond a few thousand records, the SaveChanges method really starts to break down....using (var ctx = new CustomerContext()) { List<Customer> customers = new List<Customer>(); for(int i = 0; i < 1000; i++) { list.Add(new Customer() { Name ="Customer_" + i}); } context.Customers.AddRange(list); ...

Why Async method are slow

Why EF Async Methods are Slow...Why EF async methods are slower than non-async?...Why Entity Framework async operation takes too much time as compared to a non-async operation?...StackOverflow Related Questions...Entity Framework async operation takes ten times as long to complete...Answer...The asynchronous version will always be slower than the synchronous version when there is no concurrency....It's doing all of the same work as the non-async version, but with a small amount of overhead added...

Why Detect Changes is Slow

Why DetectChanges is slow?...Why Entity Framework DetectChanges is slow?...More entities your context own, slower the DetectChanges method become!...Entity Framework does a great job detect all changes for us, but in exchange, we pay the high-performance cost!...Scenario:...Let look at this simple example to check the time taken when adding a different number of records, such as 1 record, 10, 100, 10000 records, etc....using (var ctx = new EF6.CustomerContext()) { for(int i = 0; i < lines.Count...

Why First Query is Slow

Why First Query is slow?...Why Entity Framework First Load is Slow?...Entity framework is very slow to load for the first time after every compilation especially when you have a large model....StackOverflow Related Questions...Entity Framework 6.2 very slow first startup and EFInteractiveViews...Answer...Entity Framework loads very slowly the first time because the first query EF compiles the model. If you are using EF 6.2, you can use a Model Cache which loads a prebuilt edmx when using code fi...