Last post Sep 02, 2019 09:05 AM by Brando ZWZ
Aug 15, 2019 05:07 PM|fmrock164|LINK
So my EDMX has roughly 60-70 tables/stored procs. The first time I load my application after it is published to the server its slow. Once that section has been viewed once.. the application is much faster.
I found this link and added this to my solution.
public class MyDbConfiguration : DbConfiguration
public MyDbConfiguration() : base()
var path = Path.GetDirectoryName(this.GetType().Assembly.Location);
However, it still seems slow and I feel like I am missing a step. What has everyone else done? All my google searches point back to this same type of solution.
Aug 16, 2019 12:05 AM|DA924|LINK
Aug 16, 2019 02:44 AM|Yuki Tao|LINK
It seems that only this method is currently being promoted.
What is your EF version?
I suggest to use EF 6.2,you can use a Model Cache which loads a prebuilt edmx when using code first;
If is earlier version,here are three suggestions mentioned in this post:
If you still feel very slow,I suggest you could find the reason by
F12 performance or optimize sql algorithm, and optimize query statement...
Aug 16, 2019 11:49 AM|fmrock164|LINK
I am using 6.2. Is there a setting to load a prebuilt edmx. I feel like I have missed a step. I see no EDMX file on the server.
How do I know if the pre-built edmx is actually being built?
Sep 02, 2019 09:05 AM|Brando ZWZ|LINK
As far as I know, the model cache which loads a prebuilt edmx when using code first not database first.
If you want to speed up Entity Framework, I suggest you could refer to below ways:
1.Turn off the LazyLoading (EDMX => right click the UI => properties => Lazy Loading Enabled set it to false)
2.Split your Edmx into many smaller, only include the ones you need in your page.