Startup/first query extremely slow

c# entity-framework entity-framework-core

Question

It takes a while (3 minutes+) to 'create/compile' my DbContext. The web server starts in about 5 seconds, but when I do the first query to my database, EF 2.0 has to 'build/create/compile' the database in memory or something, I think? The next requests are almost instant. This was a Database First creation of the DbContext, the database already exists in MSSQL and has data. The DbContext contains about 500 DbSet's with relations.

Is there a way to speed this up by doing the 'creation(mapping?)' of my Entity Framework's DbContext before running the web server (at developmenttime), create the file/mappings it needs, so the first request is fast too?

1
3
10/11/2017 11:38:59 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

In general this is normal Entity framework behavior by default, but from other side of cause there are some ways to resolve this course of things.

For example you can try:

  • disable database initialization
  • using pre-generation views
  • "warm" loading

Please try to read this articles:

0
12/28/2017 10:22:25 PM

Related Questions

EF6/Code First: Super slow during the 1st query, but only in Debug

I'm using EF6 rc1 with Code First strategy, without precompiled views and the problem is: If I compile and run the exe application it takes like 15 seconds to run the first query (that's okay, since I'm still working on the pre-generated views). But if I use Visual Studio 2013 Preview to Debug the exact same application it takes almost 2 minutes BE...
entity-framework entity-framework-6 visual-studio-2013
asked by Adauto Ramalho

Solutions with one EF6 model (db first) and one code first

I have a solution that has multiple databases. We are using EF6....We have one Project that is EF6 (code first), and one project that is EF6 DB first....var arkleModelDbFist = new Arkle.DAL.EF.ArkleEntities(); var CustomerOld= new Arkle.DAL.EF.Customer(); arkleModelDbFist.Customers.Add(CustomerOld); // Errors on this line arkleModelDbFist.SaveChang...
c# entity-framework entity-framework-6
asked by DermFrench

Entity Framework DBSet is extremely slow

I'm following a n-layered pattern with a services layer. No repository layer. The tutorial is ...http://techbrij.com/service-layer-entity-framework-asp-net-mvc-unit-testing... . My problem here is the ...GetAll()... method here is absurdly slow. It is taking 12 seconds to run a simple paginated query. It seems to be an issue with EFs ...DBSet..., b...
c# entity-framework entity-framework-6
asked by Taylor Mitchell

Linq query using ID returns result to slow (EF Core)

You can rewrite above query as shown below.Please let us know about the performance now.... internal List<ZipCodeInfo> GetInfoFromZipCode(string zipCode) { using (DbContext context = new DbContext()) { //disabled tracking context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking; ...
asp.net-core asp.net-mvc entity-framework entity-framework-core linq
asked by Sampath

Entity Framework - slow query after adding group by

I have a following query which runs very fast:...var query = (from art in ctx.Articles join phot in ctx.ArticlePhotos on art.Id equals phot.ArticleId join artCat in ctx.ArticleCategories on art.Id equals artCat.ArticleId join cat in ctx.Categories on artCat.CategoryId equals cat.Id where art.Active && art.ArticleCategories....
.net asp.net c# entity-framework entity-framework-6
asked by Robert

Entity Framework 6.2 very slow first startup and EFInteractiveViews

I want to know if these issues are updated in EF 6.2.0 or method of fixing it has changed, or any thing im doing wrong/should check....The answer is yes,...EF 6.2 has introduced a Model Cache...public class MyDbConfiguration : DbConfiguration { public MyDbConfiguration() : base() { var path = Path.GetDirectoryName(this.GetType().Ass...
asp.net-mvc entity-framework entity-framework-6 linq-to-entities
asked by Jonathan Magnan

EF Core - Filtering by a child collection of Key Value pairs extremely slow

Do you know what SQL is being generated by EF Core ...Any...? EF Core has the unfortunate design property of silently executing queries on the client side if they can't be translated to SQL....What if you consolidate the ...Key... and ...Value... testing?...(me.Tags.Any(met => tagSearchValues.Any(st => st.Tag == met.Tag && st.Value == met.Value))) ...
c# entity-framework entity-framework-core linq-to-sql
asked by NetMage

Querying EF Core one-to-many and further one-to-many relationship

I have 3 models, ...Competition..., ...Team... and ...TeamUser.... Each Competition has many teams and each team has many users. I want to use EF Core to bind all 3 together when returning the data to the view, but I can't really bind to users. Thus I have to implement some complex logic at my view which although it works, looks super messy and con...
asp.net-core ef-core-2.1 entity-framework-core
asked by zzdhxu

EF Core - Query with many to many relationship very slow

I want to do a "simple" query with Entity Framework Core that involves a many to many relationship. ...Currently the execution time of the query is very slow because most of it seems to be run locally. I get the following warnings in my logs:... The LINQ expression 'where ([categoryId] == [categoryRelationEntity].CategoryId)' could not be translate...
c# entity-framework-core
asked by Shamshiel

EF Core 3.1 query sometimes is superfast but sometimes is slow

I am using EF Core 3.1 with sql server 2019 Developer Edition I have a complex select query with multiple includes which 90% percent is very fast (avg 200ms) but sometimes it becomes slow (sometimes takes up to 25 seconds) for the same parameters....I have read about parameter sniffing in sql server but I don't know how to identify if this is the c...
.net c# entity-framework-core sql-server
asked by pantonis

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow