title: Entity Framework Skip/Take is very slow when number to skip is big
body: <p>So, code is very simple:</p>
  <pre><code>var result = dbContext.Skip(x).Take(y).ToList();
  </code></pre>
  <p>When x is big (~1.000.000), query is very slow. y is small - 10, 20.</p>
  <p>SQL code for this is: (from sql profiler)</p>
  <pre><code>SELECT ...
  FROM ...
  ORDER BY ...
  OFFSET x ROWS FETCH NEXT y ROWS ONLY
  </code></pre>
  <p>The question is if anybody knows how to speed up such paging?</p>