DLinq (Linq to SQL) Performance (Part 3)

LINQ to SQL: Go Rico Go!

The Wayward WebLog — Fri, 29 Jun 2007 22:43:08 GMT

Rico has his third installment on LINQ to SQL performance up on his site and he finally lets us in on what he thinks the problems are/were.

re: DLinq (Linq to SQL) Performance Part 3

Ridge — Fri, 29 Jun 2007 23:23:28 GMT

Does someone have an example of such a read-only datacontext?

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

Sidney — Sun, 01 Jul 2007 20:24:02 GMT

Rico, i realized tests with Linq in Orcas Beta 1 then developed a cache of queries compiled increasing more and more the performance, my approach was just create the entities in demand, creating a extension method called ToReader that intercepts the execution and get the internal Reader. What think?

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

Bill Schulz — Mon, 02 Jul 2007 15:27:19 GMT

I think the reason the 'select o' is slower than the 'select new { o...' version is the extra support for tracking changes. The LINQ to SQL runtime is wiring up events, etc. and this infrastructure is the expensive part.

Either query approach can (and should if it doesn't) use a forward-only, firehose cursor to get the data into memory.

As for connection pooling, the SqlConnection provides this by default. If multiple connections are opened using exactly the same connection string by the same user, the connections are pooled by default, giving the associated perf gains for free.

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

Quick LINQ link list

Linq in Action News — Thu, 05 Jul 2007 00:40:01 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:41:31 GMT

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

Quick LINQ link list

Linq in Action News — Thu, 05 Jul 2007 00:48:32 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:28 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:01 GMT

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

LINQ to SQL performance optimizations

Marco Russo — Tue, 10 Jul 2007 03:17:49 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:11 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:11 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

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

Ronan Geraghty's Weblog — Fri, 24 Aug 2007 22:27:50 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 22:27:58 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:26 GMT

Risorse su Linq to SQL

LINQ to SQL : Some of the best BLOGs

Wriju's BLOG — Thu, 01 Nov 2007 20:31:46 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:13 GMT

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

10 Tips to Improve your LINQ to SQL Application Performance

History Viewer — Mon, 05 May 2008 04:43:38 GMT

10 Tips to Improve your LINQ to SQL Application Performance

LINQ to SQL vs. ADO.NET – A Comparison

Wriju's BLOG — Thu, 17 Jul 2008 01:08:24 GMT

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

10 Tips to Improve your LINQ to SQL Application Performance

吴明浩 — Tue, 11 Nov 2008 08:07:02 GMT

Heythere,backagain.InmyfirstpostaboutLINQItriedtoprovideabrief(okay,bitdetailed)in...