性能优化实体框架查询

所以我开发了一个查询数据库的仪表板。 该数据库中存储了来自我们拥有的网站的谷歌分析的数据。

我正在使用 ASP.NET MVC 5，EF，Linq和Telerik控件/小部件。 控制器实例化一个服务层，我在其中拥有数据库上下文和业务逻辑。 每个 svc.method(( 都与一个特定的结果集有关，我将其打包到 VM 中以解包到视图中的小部件中。

目前，谷歌浏览器网络选项卡中的响应时间为5.6秒。 我已经说明了 8 种方法中的一种来向您展示我的方法。

我的问题是;如何提高性能以使页面加载速度更快？ 使每个方法异步会改善它吗？

提前感谢您提供的任何建议。

控制器：

    public ActionResult WebStats()
    {
        //other code removed for brevity
        //Service layer where the db is queried and the business logic is performend
        WebStatsService svc = new WebStatsService();
        //view model 
    WebStatsViewModel vm = new WebStatsViewModel();
        vm.PageViews = svc.GetPageViews(vm);
        vm.UniquePageViews = svc.GetUniquePageViews(vm);
        vm.UserRatioByCountry = svc.GetUserRatioByCountry(vm);
        vm.PageViewsByCountry = svc.GetPageViewsByCountry(vm);
        vm.TopTenHealthCenters = svc.GetTopTenHealthCenters(vm);
        vm.UserTypeRatio = svc.GetUserTypeRatio(vm);
        vm.TopTenHealthCentersByDateRange = svc.GetTopTenHealthCentersByDateRange(vm);
        vm.ReferralSources = svc.GetTopTenReferralSources(vm);//Get top 10 referral paths

        return View(vm);
    }

服务：

    public List<PageViews> GetPageViews(WebStatsViewModel vm)
    {
        using (ApplicationDbContext db = new ApplicationDbContext())
        {
            List<PageViews> pageViewStats = new List<PageViews>();
            var results = db.PageStats.Where(x => (vm.CMS.Equals("All") || x.Source.Equals(vm.CMS))
                                               && (vm.HealthCenter.Equals("All") || x.HealthSectionName.Equals(vm.HealthCenter))
                                               && (vm.Country.Equals("All") || x.Country.Equals(vm.Country))
                                               && (vm.City.Equals("All") || x.City.Equals(vm.City))
                                               && (x.Date >= vm.StartDate)
                                               && (x.Date <= vm.EndDate)
                                            ).Select(x => new
                                            {
                                                Date = x.Date,
                                                Total = x.PageViews
                                            }).ToList();
            var distinctDate = results.OrderBy(x => x.Date).Select(x => x.Date).Distinct();
            foreach (var date in distinctDate)
            {
                PageViews pageViewStat = new PageViews();
                pageViewStat.Date = date.Value.ToShortDateString();
                pageViewStat.Total = results.Where(x => x.Date == date).Sum(x => x.Total);
                pageViewStats.Add(pageViewStat);
            }
            return pageViewStats;
        }
    }

(vm.CMS.Equals("All") || x.Source.Equals(vm.CMS))

// Base query including static filters
var query = db.PageStats.AsQueryable();
// Apply dynamic filters
if (!vm.CMS.Equals("All"))
    query = query.Where(x => x.Source.Equals(vm.CMS));
// ...
// The rest of the query
query = query.Select(...

using (ApplicationDbContext db = new ApplicationDbContext())
{
    var query = db.PageStats
        .Where(x => x.Date >= vm.StartDate && x.Date <= vm.EndDate);
    if (!vm.CMS.Equals("All"))
        query = query.Where(x => x.Source.Equals(vm.CMS));
    if (!vm.HealthCenter.Equals("All"))
        query = query.Where(x => x.HealthSectionName.Equals(vm.HealthCenter));
    if (!vm.Country.Equals("All"))
        query = query.Where(x => x.Country.Equals(vm.Country));
    if (!vm.City.Equals("All"))
        query = query.Where(x => x.City.Equals(vm.City));
    query = query
        .GroupBy(x => x.Date)
        .Select(g => new
        {
            Date = g.Key,
            Total = g.Sum(x => x.PageViews)
        })
        .OrderBy(x => x.Date);
    var pageViewStats = query
        .AsEnumerable() // SQL query ends here
        .Select(x => new PageViews
        {
            Date = x.Date.Value.ToShortDateString(),     
            Total = x.Total
        })
        .ToList();
    return pageViewStats;
}