title: Slow loading first page - ASP.NET MVC
body: <p>I used miniprofiler for my page because I think I have big loading time for my first page and some other pages. I am starting with miniprofiler but I think it is very good tool. I have this result:</p>
  
  <ul>
  <li><code>http://localhost:50783/</code>     192.2  +0.0<br>
  <ul>
  <li>Getting articles from database     2.2    +186.9   </li>
  <li>Find: Index  866.4  +190.9   </li>
  <li>Render : Index  1839.0  +1058.1<br>
  <ul>
  <li>Find: _Article    530.0  +2809.0    </li>
  <li>Render partial: _Article  64.3   +3339.2    </li>
  <li>Render partial: _Article  8.2    +3404.2    </li>
  <li>Render partial: _Article  12.5   +3413.0    </li>
  <li>Render partial: _Article  8.7    +3426.2    </li>
  <li>Render partial: _Article  7.9    +3435.4    </li>
  <li>Render partial: _LeftMenu     64.8   +3520.4</li>
  <li>Render partial: _LogOnPartial     3.3    +3556.3    </li>
  <li>Render partial: _RightMenuTest    2530.1 +3591.2</li>
  <li>Render partial: _NextMatch    3.5    +4088.7</li>
  <li>Render partial: _Standings    4.7    +4226.5    </li>
  <li>Render partial: _Footer   21.2   +6137.4</li>
  </ul></li>
  </ul></li>
  </ul>
  
  <p>Can anybody help me with reducing that times where is Find? What it means? I know that RightMenuTest has the biggest time and I am trying to reduce it too. I have many my own helpers there and I think that is problem with partial view _RightMenuTest. So I need help with reducing that others times.</p>
  
  <p>Thank you</p>
  
  <p>Edited:</p>
  
  <p>_Article:</p>
  
  <pre><code>@model SkMoravanSvitavka.Models.Article
  &lt;h3&gt;@Html.ActionLink(Model.Title, "Zobrazit", "Clanek", new { id = Model.ArticleID }, null)&lt;/h3&gt;
  
      &lt;p&gt;@Html.Raw(Html.ArticleImageToSmall(Html.Article(Model.Text))) &lt;/p&gt;
  
  @Html.ActionLink("Počet komentářů:" + Model.Comments.Count, "Zobrazit", "Clanek", new { id = Model.ArticleID }, null)
  </code></pre>
  
  <p>Index view for article:</p>
  
  <pre><code>@model IEnumerable&lt;SkMoravanSvitavka.Models.Article&gt;
  @{
      ViewBag.Title = "Sk Moravan Svitávka - oficiální stránky fotbalového klubu";
  }
  @if (Model != null)
  {
      foreach (var item in Model)
      {
          @Html.Partial("_Article", item);
      }
  }
  </code></pre>
  
  <p>Index in controller for article:</p>
  
  <pre><code>public ActionResult Index()
          {
              var profiler = MiniProfiler.Current;
              using (profiler.Step("Getting articles from database"))
              {
                  var model = repo.GetLatestArticles(5);
                  return View(model);
              }
          }
  </code></pre>