title: Better Performance Linq To SQl query
body: <p>Is there a way to increase the fetching performance of my LINQ to SQL query where its total count is more than a hundred thousand? Should I separate  the total data to 5 parts by using skip or take? My query, when fetching, took more than 40 minutes.</p>
  
  <pre><code>   Dim query = From a In context.Orders
                          Join b In context.Status On a.OrderItem Equals b.OrderItem
                          Join c In context.Summary On a.OrderItem.Substring(0, 16) Equals c.OrderSuffix
                          Where Not (b.Status.Contains("E")) And a.Type = "AG" And a.OrderItem = b.OrderItem And a.OrderItem.Substring(0, 16) = c.OrderSuffix
                          Order By a.OrderItem.Substring(0, 16), a.Agn Ascending
                          Select a.OrderItem,
                          JobOr = a.auftrag_nr.Substring(0, 16),
                          Suffix = (a.auftrag_nr.Substring(0, 16).Substring(13)),
                          a.Agn,
                          a.Base,
                          b.Status,
                          a.Group,
                          a.Machine,
                          a.Article,
                          a.Height,
                          a.Sol, c.plan, a.DatePlanned
  </code></pre>