Our database contains around 170 entities (tables), with the primary table having about 150,000 entries, and we are utilising EF 6.0,.NET 4.5, and the code first methodology. The entity framework takes around 25 seconds to load the first time. I'm attempting to speed up this time since it's too sluggish and becomes slower as more records are added. I tried creating native graphics and utilising interactive views that were already created, but I was unable to make any appreciable progress.
Can someone please assist me with this?