title: Group by with paging (take skip)
body: <p>I am trying to make some kind of paging. But, I need to do it on a grouped result, because every time I do a page. It is a requirement that all data for a given group is fetched.</p>
  
  <p>Below code:</p>
  
  <pre><code>var erere = dbCtx.StatusViewList
                   .GroupBy(p =&gt; p.TurbineNumber)
                   .OrderBy(p =&gt; p.FirstOrDefault().TurbineNumber)
                   .Skip(0)
                   .Take(10)
                   .ToList();
  </code></pre>
  
  <p>I have 200k items and the statement above seems to be so slow the connection times out. My best bet is its the orderby that slows it down. Any suggestions how to do this, or how to speed the statement above up?</p>