Azure 上的 MVC 网站首次加载每个页面时速度非常慢

解决 Azure 上的 MVC 网站首次加载速度慢的问题

csharp
public IEnumerable GetUsers()
{
    using (var context = new MyDbContext())
    {
        // 添加索引
        context.Users.Include(u => u.Roles).Load();
        // 避免全表扫描
        return context.Users.Where(u => u.IsActive).ToList();
    }
}

csharp
public IEnumerable GetUsers()
{
    var cacheKey = "users";
    var cache = Connection.GetDatabase();
    var users = cache.Get>(cacheKey);
    if (users != null)
    {
        return users;
    }
    using (var context = new MyDbContext())
    {
        users = context.Users.ToList();
        // 将数据存入缓存，设置过期时间
        cache.Set(cacheKey, users, TimeSpan.FromMinutes(10));
    }
    return users;
}

csharp
public class BundleConfig
{
    public static void RegisterBundles(BundleCollection bundles)
    {
        bundles.Add(new ScriptBundle("~/bundles/jquery").Include(
                    "~/Scripts/jquery-{version}.js"));
        bundles.Add(new StyleBundle("~/Content/css").Include(
                    "~/Content/site.css"));
    }
}

csharp
public class BundleConfig
{
    public static void RegisterBundles(BundleCollection bundles)
    {
        bundles.UseCdn = true;
        var jqueryCdnPath = "https://code.jquery.com/jquery-3.6.0.min.js";
        bundles.Add(new ScriptBundle("~/bundles/jquery", jqueryCdnPath).Include(
                    "~/Scripts/jquery-{version}.js"));
        var cssCdnPath = "https://cdn.example.com/content/site.css";
        bundles.Add(new StyleBundle("~/Content/css", cssCdnPath).Include(
                    "~/Content/site.css"));
    }
}