Linq performance articles

by ChrisB July 17, 2007 11:07
There's a nice series of LINQ performance articles from Rico Mariani.  I haven't run my own speed tests yet, but he claims that they've increased the speed markedly from Beta 1 too Beta 2.Beta 1 was running select queries at about 1/8 the speed of a DataReader (LINQ uses datareaders under the covers), but they have made a 3.8x improvement under the covers with Beta 2.He discusses compiled queries where you can define the query, and execute it later with parameters (sounds a bit like a stored procedure!)  This means that LINQ doesn't need to generate the SQL each time the query is called, thus saving time on each execution.  By using compiled queries you can achieve a 6.6x improvement over beta 1, or a speed of around 93% that of a raw datareader.The series of articles is herePart 1, Part 2, Part 3, Part 4, Part 5.(I've posted this mainly as a bookmark for myself).[tags]LINQ, Orcas, .net 3.5, database[/tags]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Archive

Comments

Add comment


 

  Country flag

biuquote
  • Comment
  • Preview
Loading



Powered by BlogEngine.NET 1.4.5.0
Theme by Mads Kristensen | Modified by Mooglegiant

About the author

Chris Buckett develops .net applications in C# and VB.Net, and is being persuaded to start developing for Java.

Tag cloud

Page List