http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspxQuery Performance During this post I’ll show a few patterns on how to improve the query performance. A major design element for performance is the query cache. Once a query is executed, parts of the query are maintained in a global cache. Because of queryenCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#7624398Tue, 12 Feb 2008 02:45:19 GMT91d46819-8472-40ad-a661-2c78acb4018c:7624398Ryan<p>Do you have any comparison between doing LINQ like </p> <p>'from x in y select x;'</p> <p>vs.</p> <p>'x.Select()'</p> <p>More complex queries would be more useful but I am interested in which type is actually faster</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#7629210Tue, 12 Feb 2008 06:01:14 GMT91d46819-8472-40ad-a661-2c78acb4018c:7629210Phil Bolduc<p>I assume you took into consideration the database buffer cache?</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#7629339Tue, 12 Feb 2008 06:05:38 GMT91d46819-8472-40ad-a661-2c78acb4018c:7629339Jim Wooley<p>I'm glad to finally see some EF performance information. It would be helpful to see a comparison against the similar process with a DataReader, DataSet, LINQ to SQL and other OR Mappers to see just what the performance trade-offs are. In this regard, I point to Rico Mariani's series on performance with LINQ to SQL as an example.</p> <p>In the case of the examples you've presented so far, the queries are identical to the kind of 1-1 table mapping that is possible with LINQ to SQL. It would be nice to also see some performance on more complex object mapping schemes (multiple tables to single object for example).</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#7636598Tue, 12 Feb 2008 12:22:29 GMT91d46819-8472-40ad-a661-2c78acb4018c:7636598Cosmin<p>Is there any way that we can reduce the time when the first query is run? I thought that using compiled queries would reduce that time.</p> <p>Thank you.</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#7651896Tue, 12 Feb 2008 22:33:53 GMT91d46819-8472-40ad-a661-2c78acb4018c:7651896JuST ANOTHER GeeK<p>ADO.NET Entity FrameWork Performance</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#7660629Wed, 13 Feb 2008 05:34:57 GMT91d46819-8472-40ad-a661-2c78acb4018c:7660629juliel<p>Brian</p> <p>Thank you so much for going into this detail. I look forward to more.</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#7673210Wed, 13 Feb 2008 16:20:27 GMT91d46819-8472-40ad-a661-2c78acb4018c:7673210Matthieu MEZIL<p>J'ai quelque peu d&#233;laiss&#233; mon blog ces derniers temps mais maintenant que les techdays sont pass&#233;s (du</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#7682278Thu, 14 Feb 2008 02:27:21 GMT91d46819-8472-40ad-a661-2c78acb4018c:7682278QuintaStation<p>En este post comento una serie buenas pr&#225;cticas para mejorar la eficiencia de ADO.NET Entity Framework</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#7725371Sat, 16 Feb 2008 03:29:45 GMT91d46819-8472-40ad-a661-2c78acb4018c:7725371Jim L<p>What is the ability to persist this global cache? Given that the abstraction layer probably doesn't change a heck of a lot, there's no need to rebuild it unless it is invalidated. I'd hate to put the user through unneeded work if its not quick.</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#7775479Mon, 18 Feb 2008 18:42:34 GMT91d46819-8472-40ad-a661-2c78acb4018c:7775479Brian Vallelunga<p>I'm very curious about best-practices for an asp.net environment. Obviously, keeping around the compiled query would be great for the performance benefits of subsequent queries, yet in a web scenario, I'm generally creating a context, executing a query, and then destroying both. Is there some advice out there about how to make this more efficient so that I don't pay the 200ms penalty each time?</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#7778705Mon, 18 Feb 2008 22:14:41 GMT91d46819-8472-40ad-a661-2c78acb4018c:7778705JasonBSteele<p>In the stats above it appears that there is a decrease in performance for the &quot;No Tracking&quot; in several scenarios for the first run. For example, in the LINQ no parameters scenario the Tracking time is 202, whereas the No Tracking time is 282.</p> <p>Is it true that No Tracking is actually slower in some cases, and if so why?</p> <p>Many Thanks</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#7819325Wed, 20 Feb 2008 18:23:31 GMT91d46819-8472-40ad-a661-2c78acb4018c:7819325TerryLee<p>概述春节后的第一期推荐系列文章，共有10篇文章：1.ASP.NETMVCExampleApplicationoverNorthwindwiththeEntityFramework...</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#7821153Wed, 20 Feb 2008 20:44:08 GMT91d46819-8472-40ad-a661-2c78acb4018c:7821153El blog de Vicente<p>Como hace unos d&#237;as apuntaba Unai , en el blog del equipo de desarrollo de ADO.NET est&#225;n publicando una</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#7826848Thu, 21 Feb 2008 04:33:56 GMT91d46819-8472-40ad-a661-2c78acb4018c:7826848Jacky_Xu<p>概述 春节后的第一期推荐系列文章，共有10篇文章： 1.ASP.NETMVCExampleApplicationoverNorthwindwiththeEntityFr...</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#7841949Fri, 22 Feb 2008 00:28:20 GMT91d46819-8472-40ad-a661-2c78acb4018c:7841949Hot Topics<p>The first post, Exploring the Performance of the ADO.NET Entity Framework - Part 1 , began: Performance</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#8130853Mon, 10 Mar 2008 15:16:15 GMT91d46819-8472-40ad-a661-2c78acb4018c:8130853Ayman Saleh<p>Do you have any performance statistics relating to using SQL Server stored procedures?</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#8171194Wed, 12 Mar 2008 19:12:43 GMT91d46819-8472-40ad-a661-2c78acb4018c:8171194TJE<p>I love all the amazing work that has been done with the ADO.NET Entity Framework and Data Services. &nbsp;There is one piece that I can't find any information on, however: &nbsp;Support for multi domain models or multiple databases in the Entity Framework (and thus Data Services).</p> <p>We have 10+ large enterprise databases all hosted on the same server/instance of sql server and these databases are somewhat used as &quot;schema&quot; conatiners, i.e. we have many stored procedures that make calls to stored procedures/tables/views in another database and there are logical relationships between tables in different databases. &nbsp;This requires our Entity Model to have entity relationships across databases and thus across Entity Models (since, AFAIK, currently the Entity Framework design surface can only include tables from one database).</p> <p>I believe that this is a big weakness and needs to be addressed as soon as possible. &nbsp;The other issue I have is how much the Entity Framework design surface slows down (and the entity boxes become unmanageble from a visual real-estate perspective) after about 20-30 tables on it...</p> <p>Any comments on this from the Entity Framework team would be very much appreciated...</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#8289605Mon, 17 Mar 2008 17:52:25 GMT91d46819-8472-40ad-a661-2c78acb4018c:8289605Paymon<p>Great post!</p> <p>It will be helpful if you could also include comparison metrics from the DBMS side.</p> <p>Splitting the execution time between application (CLR) and Sql server (DBMS) for each thread will also be of a huge help in understanding and tuning performance.</p> <p>Thanks</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#8326090Wed, 19 Mar 2008 21:53:30 GMT91d46819-8472-40ad-a661-2c78acb4018c:8326090Brian Dawson - MSFT<p>Thanks for all the comments and questions! &nbsp;It's great to see the interest in the Entity Framework. I'm working on another post about performance that I'll try to post soon. It addresses some of the questions.</p> <p>-Brian</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#8326994Thu, 20 Mar 2008 08:48:09 GMT91d46819-8472-40ad-a661-2c78acb4018c:8326994Ranga<p>Is there any news on the Release Date of Entity Framework?</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#8340746Fri, 28 Mar 2008 04:48:40 GMT91d46819-8472-40ad-a661-2c78acb4018c:8340746ADO.NET team blog<p>There have been a few questions from the last performance blog post about how the Entity Framework compares</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#8341265Fri, 28 Mar 2008 11:53:56 GMT91d46819-8472-40ad-a661-2c78acb4018c:8341265Matthieu MEZIL<p>L'ADO .Net Team vient de poster deux nouveaux posts : le premier concerne l'utilisation des proc&#233;dures</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#8549427Sun, 25 May 2008 01:01:05 GMT91d46819-8472-40ad-a661-2c78acb4018c:8549427Damir Dobric Posts<p>For everybody who is interested on internals of Entity Framework (ER) in relation to referential integrity</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#8567613Sun, 01 Jun 2008 16:33:24 GMT91d46819-8472-40ad-a661-2c78acb4018c:8567613Dating<p>Query Performance During this post I’ll show a few patterns on how to improve the query performance. A major design element for performance is the query cache. Once a query is executed, parts of the query are maintained in a global cache. Because of quer</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#8575578Thu, 05 Jun 2008 19:08:15 GMT91d46819-8472-40ad-a661-2c78acb4018c:8575578Weddings<p>Query Performance During this post I’ll show a few patterns on how to improve the query performance. A major design element for performance is the query cache. Once a query is executed, parts of the query are maintained in a global cache. Because of quer</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#8738632Wed, 16 Jul 2008 16:59:47 GMT91d46819-8472-40ad-a661-2c78acb4018c:8738632André Magalhães<p>Analyzing the test results, to use compiled LINQ queries is better than non-compiled LINQ queries only in the second execution. In the first execution the compiled LINQ queries are always slower. </p> <p>But what is exactly the second execution? Is an execution using the same instance of the objectcontext or is an execution in a new thread with a new objectcontext?</p> <p>What I mean is, does the query cache survive between different threads or it is alive just during a thread execution lifetime?</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#8883732Thu, 21 Aug 2008 09:50:39 GMT91d46819-8472-40ad-a661-2c78acb4018c:8883732Podlipensky<p>Do you have comparsion data for EF with stored procedures and standalone stored procedures? Does it have some perfomance difference?</p> http://blogs.msdn.com/adonet/archive/2008/02/11/exploring-the-performance-of-the-ado-net-entity-framework-part-2.aspx#9306088Sun, 11 Jan 2009 20:40:19 GMT91d46819-8472-40ad-a661-2c78acb4018c:9306088Jiří {x2} Činčura<p>If we’ll skip exact details, we can say, that internal behavior of whole modeling and mapping is based</p>