Entity framework very slow to load for first time after every compilation

by

On the first query EF compiles the model. This can take some serious time for a model this large.

Here are 3 suggestions: http://www.fusonic.net/en/blog/2014/07/09/three-steps-for-fast-entityframework-6.1-first-query-performance/

A summary:

  1. Using a cached db model store
  2. Generate pre-compiled views
  3. Generate pre-compiled version of entityframework using n-gen to avoid jitting

I would also make sure that I compile the application in release mode when doing the benchmarks.

Another solution is to look at splitting the DBContext. 400 entities is a lot and it should be nicer to work with smaller chunks. I haven’t tried it but I assume it would be possible to build the models one by one meaning no single load takes 15s. See this post by Julie Lerman https://msdn.microsoft.com/en-us/magazine/jj883952.aspx

More Related Contents:

  1. summing values of a column based on id [closed]
  2. MSSQL Error ‘The underlying provider failed on Open’
  3. Conversion of a datetime2 data type to a datetime data type results out-of-range value
  4. Getting data from stored procedure with Entity Framework
  5. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  6. How can I lock a table on read, using Entity Framework?
  7. Mapping composite keys using EF code first
  8. EF 6 – How to correctly perform parallel queries
  9. Entity-framework code is slow when using Include() many times
  10. ‘datetime2’ error when using entity framework in VS 2010 .net 4.0
  11. Delete a single record from Entity Framework?
  12. Optimistic concurrency: IsConcurrencyToken and RowVersion
  13. Entity Framework 6 transaction rollback
  14. The LINQ expression could not be translated and will be evaluated locally
  15. Dynamic query with OR conditions in Entity Framework
  16. Entity Framework | Sequence contains more than one matching element
  17. Keyword Not Supported: Metadata
  18. Why is EF generating SQL queries with unnecessary null-checks?
  19. How to Specify Primary Key Name in EF-Code-First
  20. How to Identify the primary key duplication from a SQL Server 2008 error code?
  21. Should the order of LINQ query clauses affect Entity Framework performance?
  22. Watch for a table new records in sql database
  23. EntityType has no key defined error
  24. Can I reuse code for selecting a custom DTO object for a child property with EF Core?
  25. How to Bulk Update records in Entity Framework?
  26. Any way to SQLBulkCopy “insert or update if exists”?
  27. DbSet.Attach(entity) vs DbContext.Entry(entity).State = EntityState.Modified
  28. Is it possible to use SqlGeography with Linq to Sql?
  29. Cannot find command ‘dotnet ef’
  30. How do I connect to a SQL database from C#?

Leave a Comment