CODEWITHSUNDEEP
linq
Markus
Markus

Reputation: 1485

Is LINQ generally slower than a equal SQL statement

If I write a large SQL statement with many group by clauses and so on; would it be much faster with normal SQL (maybe a stored procedure), or is Linq only parsing it to a very nice SQL statement and gives me my results quite fast?

Upvotes: 5

Views: 1905

Answers (1)

Jon Skeet
Jon Skeet

Reputation: 1499740

In some cases you may be able to tune the SQL better than LINQ to SQL... but LINQ really is running SQL. It's not fetching all the data into the process and then doing the processing. You can (and should) log what SQL is being generated and profile anything that looks suspicious.

Of course, there's the overhead of converting the query into SQL to start with (which is why you're able to precompile them) and then there's the overhead of converting the data into objects - and keeping track of the IDs etc. In my experience this is usually not a significant overhead though. As ever, profile your code...

Upvotes: 10

Related Questions