Speeding up LINQ to SQL queries

Question

What are the common things that we can keep in mind while writing the LINQ to SQL query for optimizing or speeding up the LINQ to SQL?.

For example, ordinarily, LINQ to SQL must translate LINQ queries to SQL every time a query executes; this involves recursing the expression tree that makes up the query in several stages. What we do is like precompiling the query using the CompiledQuery class.

score 5 · Accepted Answer · edited May 23 '17 at 12:01

5

There is one helpful thing about LINQ that every developer should know. It is about performance of Join vs Where.

The full discussion can be seen here why is join so much faster than where

edited May 23 '17 at 12:01

Community

1
1

answered Apr 18 '14 at 09:23

Mare Infinitus

8,024
8
64
113

score 1 · Answer 2 · answered Apr 18 '14 at 10:54

1

usually the native LINQ2SQL compiler lets you forget about the whole optimizing queries trouble, however there are some caveats regarding mostly with compiled queries abuse. Here are some resources you should check about it. :)

http://visualstudiomagazine.com/articles/2010/06/24/five-tips-linq-to-sql.aspx http://weblogs.asp.net/dixin/archive/2011/01/31/understanding-linq-to-sql-11-performance.aspx

answered Apr 18 '14 at 10:54

p.chang

23
6

How exactly the Linq2Sql compiler lets you forget about optimization? It's pretty basic and doesn't have any knowledge about table indexes. – d_z Apr 18 '14 at 11:30

Speeding up LINQ to SQL queries

2 Answers2