DLinq (Linq to SQL) Performance (Part 2)

LINQ to SQL: Under the Microscope

The Wayward WebLog — Tue, 26 Jun 2007 05:53:19 GMT

Rico continues his series on LINQ to SQL performance. In this post he takes a look at the breakdown of

re: DLinq (Linq to SQL) Performance (Part 2)

Bill Graziano — Tue, 26 Jun 2007 07:51:48 GMT

I think what you're describing is called a stored procedure in the DBA community. :)

re: DLinq (Linq to SQL) Performance (Part 2)

Frans Bouma — Tue, 26 Jun 2007 10:47:34 GMT

What I'd like to know is which tool is used to get the list of numbers you show? When I profile our o/r mapper framework I in general do that on debug build code to see what the true costs are of the algorithms and the code used, but when I profile the release build, I'll never be able to get e.g. JIT costs...

It might be interesting to know how exactly one should profile code to get a good overview what's REALLY going on. Profiling, like debugging, is IMHO a black art: a novice is likely stare at the profiler report for hours without knowing where to begin optimizing.

re: DLinq (Linq to SQL) Performance (Part 2)

Pablo Castilla — Tue, 26 Jun 2007 16:25:39 GMT

could you repeat the benchmarks with orcas to see if there is any improvement?

re: DLinq (Linq to SQL) Performance (Part 2)

Anders Borum — Tue, 26 Jun 2007 20:52:26 GMT

Converting regular LINQ expressions to compiled queries quickly becomes a trivial task, and I hope that most LINQ to SQL developers realize, that this is a pattern they should look into (it's a prime pattern candidate the LINQ to SQL team to focus on when writing docs and samples).

Looking forward to the 3rd part.

re: DLinq (Linq to SQL) Performance (Part 2)

rogerj — Thu, 28 Jun 2007 04:45:50 GMT

Rico,

I've run some performance comparisons between LINQ to SQL parameterized and compiled queries with varying numbers of returned rows in http://oakleafblog.blogspot.com/2007/06/rico-mariani-dlinq-performance-tips.html.

--rj

re: DLinq (Linq to SQL) Performance (Part 2)

rogerj — Fri, 29 Jun 2007 17:28:32 GMT

There's actual data that compares parameterized and compiled query performance with some updates on compiled queries and DataContext objects at http://oakleafblog.blogspot.com/2007/06/rico-mariani-dlinq-performance-tips.html.

--rj

DLinq (Linq to SQL) Performance Part 3

Rico Mariani's Performance Tidbits — Fri, 29 Jun 2007 19:01:47 GMT

I’d like to start with a little housekeeping. Some readers asked me how I made the nifty table in part

re: DLinq (Linq to SQL) Performance (Part 2)

Ridge — Fri, 29 Jun 2007 23:22:39 GMT

So I'm unclear here... Are you advocating that the end-user developer create compiled queries for best perf or are you suggesting that behind-the-scenes (post beta 1) that you're doing this for us?

Quick LINQ link list

Linq in Action News — Thu, 05 Jul 2007 00:39:59 GMT

Some quick links about LINQ: Articles about extension methods by the Visual Basic team Third-party LINQ

Quick LINQ link list

Fabrice's weblog — Thu, 05 Jul 2007 00:40:00 GMT

Some quick links about LINQ: Articles about extension methods by the Visual Basic team Third-party LINQ

LINQ to SQL performance

Public Sector Developer Weblog — Fri, 06 Jul 2007 00:31:51 GMT

One of the things I get asked quite often is "How does LINQ to SQL affect performance compared to writing

LINQ to SQL performance

Noticias externas — Fri, 06 Jul 2007 00:55:24 GMT

One of the things I get asked quite often is "How does LINQ to SQL affect performance compared to

linq to sql 的动态条件查询方法

neuhawk — Sat, 07 Jul 2007 11:15:06 GMT

linq to sql 的动态条件查询方法

LINQ to SQL performance optimizations

Marco Russo — Tue, 10 Jul 2007 03:17:46 GMT

Rico Mariani did a very good job analyzing performance implications of LINQ to SQL queries. He is currently

LINQ to SQL and (micro) Performance

Mike Taulty's Blog — Tue, 17 Jul 2007 12:18:07 GMT

Also been catching up on Rico Mariani's notes on improvements to LINQ to SQL performance between the...

Community Convergence XXIX

Charlie Calvert's Community Blog — Mon, 13 Aug 2007 09:36:19 GMT

There are several good new blogs from members of the community team. Nevertheless, the most important

LINQ to SQL - compiled queries (with working example for beta 2)

Ronan Geraghty's Weblog — Fri, 24 Aug 2007 20:03:10 GMT

I've been meaning to dig into LINQ performance for some time (actually since it came up during one of

LINQ to SQL - compiled queries (with working example for beta 2)

MSDN Ireland Blog — Fri, 24 Aug 2007 20:03:11 GMT

I've been meaning to dig into LINQ performance for some time (actually since it came up during one of

Risorse su Linq to SQL

jankyBlog — Mon, 27 Aug 2007 10:58:24 GMT

Risorse su Linq to SQL

LINQ to SQL : Some of the best BLOGs

Wriju's BLOG — Thu, 01 Nov 2007 20:31:45 GMT

Some of the best blogs on LINQ to SQL I found are available for great learning, Scott Guthrie The Famous

DLinq (Linq to SQL) Performance (Part 1)

Rico Mariani's Performance Tidbits — Thu, 15 Nov 2007 04:21:11 GMT

[ By popular demand, here are links for all 5 parts in the series Part 1 , Part 2 , Part 3 , Part 4 ,

LINQ to SQL vs. ADO.NET – A Comparison

Wriju's BLOG — Thu, 17 Jul 2008 01:07:59 GMT

ADO.NET is our contemporary data access component and now we have written many applications. Now there