Doubt cache Asp.net MVC

Question

I have the following scenario:

Public ActionResult ProdutoFornecedor01()
{
     var produtos = _db.Produtos.Include(x => x.Fornecedor).OrderByDescending(x => x.ProdutoId).Where(x => x.Fornecedor.Id == 1).Take(10);
     return PartialView("_PartialProdutosFornecedor01", produtos);
}

Public ActionResult ProdutoFornecedor02()
{
     var produtos = _db.Produtos.Include(x => x.Fornecedor).OrderByDescending(x => x.ProdutoId).Where(x => x.Fornecedor.Id == 2).Take(10);
     return PartialView("_PartialProdutosFornecedor02", produtos);
}

Public ActionResult ProdutoFornecedor03()
{
     var produtos = _db.Produtos.Include(x => x.Fornecedor).OrderByDescending(x => x.ProdutoId).Where(x => x.Fornecedor.Id == 3).Take(10);
     return PartialView("_PartialProdutosFornecedor03", produtos);
}

In my View Index I call the PartialView:

<div class="row">
     @Url.Action("ProdutoFornecedor01", "Produtos")
</div>

<div class="row">
     @Url.Action("ProdutoFornecedor02", "Produtos")
</div>

<div class="row">
     @Url.Action("ProdutoFornecedor03", "Produtos")
</div>

According to my Hosting Plan, there are many requests in the database.

I tried to use a Cache:

[OutputCache(Duration = 600, VaryByParam = "*")]

But the customer complained that when upgrading with a new product it takes to appear on Home.

What is the best way around this problem?

Answer 1

You can keep the cache, and during the insertion of a product by the customer, update the cache referring to the list of products of this client, as if it were a TRIGGER.

This way the cache is only updated when a product is inserted, I suppose it is less frequently and will decrease the access to BD.

Answer 2

@Hermes

First, it will depend on the amount of records you are sending. You can async call with the Entity Framework

One of the ways to load more "fast" your home, is you load your views async with ajax.

In the following way: In your view

<div class="row">
   <div class="partial" [email protected]("Action","Controller")></div>
</div>
<div class="row">
   <div class="partial" [email protected]("Action","Controller")></div>
</div>
<div class="row">
   <div class="partial" [email protected]("Action","Controller")></div>
</div>

and his js:

$('.partial').each(function(index,item) { 
   var url = $(item).data("url");
   if(url && url.length >0) {
     $(item).load(url);
   }
});