http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspxPerformance Matters No matter what type of application you are developing at some point in the lifecycle of a software application or service, performance matters; this is especially true when accessing data. In this article, I’m going to spend some timeenCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#7445571Mon, 04 Feb 2008 23:02:58 GMT91d46819-8472-40ad-a661-2c78acb4018c:7445571Yurik<p>In the first run explanation (#1), you listed these two points:</p> <p>* Initializing Metadata 14%– During the initialization of the metadata, the connection is opened and the actual metadata information is retrieved from the ADO.NET Data Provider which gets information from the database.</p> <p>* Opening Connection 8%– This is simply just opening the database connection; the first time is usually the slowest.</p> <p>But why is opening connection so high? If the ADO.NET provider has to get information from the DB, it would have to open a connection? Do you imply that the connection is then closed and reopened? In which case the 8% would always take the same time as this opening is not the first one. Thanks!</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#7520313Thu, 07 Feb 2008 19:57:43 GMT91d46819-8472-40ad-a661-2c78acb4018c:7520313O bruxo mobile<p>El equipo de ADO.NET hace unos dias ha publicado un interesante post sobre rendiemiento de Entity Framework</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#7524825Thu, 07 Feb 2008 23:05:41 GMT91d46819-8472-40ad-a661-2c78acb4018c:7524825Hot Topics<p>Two great posts appeared recently on the ADO.NET team blog. The first details some of the performance</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#7601659Mon, 11 Feb 2008 08:37:17 GMT91d46819-8472-40ad-a661-2c78acb4018c:7601659Gustavo<p>So if it takes so much time to create the ObjectContext, should I create it before hand? In other words, in a windows app, can I just create the ObjectContext when the app loads and the user logs-in, and then use the ObjectContext until the user logs-out or close the app?</p> <p>In the demos and examples I see this objects being created in a &quot;using&quot;, implying that I should create it before every chunk of database operation.</p> <p>Can you please clarify that? </p> <p>Thanks!</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#7613764Mon, 11 Feb 2008 18:53:59 GMT91d46819-8472-40ad-a661-2c78acb4018c:7613764Brian Dawson - MSFT<p>Great question about the connection. The first opening does including getting additional information. We do open and close the connection when needed and the times are faster over time.</p> <p>As for the ObjectContext and best practice, this really just depends on your application. The first run really is the slowest with the ObjectContext. &nbsp;There is more than just performance you need to take into account when considing using a longer running ObjectContext. &nbsp;For example, do you need to track entities longer? If so than &quot;using&quot; may not be the right pattern. The using makes a nice pattern for short lived context, such as in the ASP.NET scenarios.</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#7621821Tue, 12 Feb 2008 00:50:45 GMT91d46819-8472-40ad-a661-2c78acb4018c:7621821Gustavo<p>Thank you very much Brian! </p> <p>The scenario I had in mind when suggested the use of a long running ObjectContext was a Windows app, in which tracking entities for a long time is required - an order taking app for instance.</p> <p>Thanks again.</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#7663227Wed, 13 Feb 2008 07:43:49 GMT91d46819-8472-40ad-a661-2c78acb4018c:7663227LINQ Recipes<p>Exploring the Performance of the ADO.NET Entity Framework</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#7673212Wed, 13 Feb 2008 16:20:32 GMT91d46819-8472-40ad-a661-2c78acb4018c:7673212Matthieu 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/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#7682266Thu, 14 Feb 2008 02:27:07 GMT91d46819-8472-40ad-a661-2c78acb4018c:7682266QuintaStation<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/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#7819296Wed, 20 Feb 2008 18:20:33 GMT91d46819-8472-40ad-a661-2c78acb4018c:7819296TerryLee<p>概述春节后的第一期推荐系列文章，共有10篇文章：1.ASP.NETMVCExampleApplicationoverNorthwindwiththeEntityFramework...</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#7821152Wed, 20 Feb 2008 20:44:02 GMT91d46819-8472-40ad-a661-2c78acb4018c:7821152El 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/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#7826844Thu, 21 Feb 2008 04:33:29 GMT91d46819-8472-40ad-a661-2c78acb4018c:7826844Jacky_Xu<p>概述 春节后的第一期推荐系列文章，共有10篇文章： 1.ASP.NETMVCExampleApplicationoverNorthwindwiththeEntityFr...</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#7841948Fri, 22 Feb 2008 00:28:11 GMT91d46819-8472-40ad-a661-2c78acb4018c:7841948Hot 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/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#7939318Fri, 29 Feb 2008 04:54:25 GMT91d46819-8472-40ad-a661-2c78acb4018c:7939318Karol Deland<p>It's cool to have an idea of the performance of the EF. Nonetheless, I think a comparison must be shown between the dataset world and Linq to Entities. It would be interesting to have the overhead of each compared. </p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#8340745Fri, 28 Mar 2008 04:48:36 GMT91d46819-8472-40ad-a661-2c78acb4018c:8340745ADO.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/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#8341264Fri, 28 Mar 2008 11:53:51 GMT91d46819-8472-40ad-a661-2c78acb4018c:8341264Matthieu 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/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#8447236Thu, 01 May 2008 19:50:38 GMT91d46819-8472-40ad-a661-2c78acb4018c:8447236Morten Mertner<p>It doesn't take a performance test to tell you that EF will be MUCH, MUCH faster than any DataSet, which has to be some of the worst code in the entire BCL.</p> <p>I've written an ORM that uses tons of reflection, runtime schema analysis, runtime SQL generation, etc - and it outperformed typed DataSets (where queries and all such are generated at design-time) by several factors.</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#8549426Sun, 25 May 2008 01:00:59 GMT91d46819-8472-40ad-a661-2c78acb4018c:8549426Damir 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/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#8567471Sun, 01 Jun 2008 13:20:48 GMT91d46819-8472-40ad-a661-2c78acb4018c:8567471Dating<p>Performance Matters No matter what type of application you are developing at some point in the lifecycle of a software application or service, performance matters; this is especially true when accessing data. In this article, I’m going to spend some tim</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#8577062Fri, 06 Jun 2008 09:09:40 GMT91d46819-8472-40ad-a661-2c78acb4018c:8577062Weddings<p>Performance Matters No matter what type of application you are developing at some point in the lifecycle of a software application or service, performance matters; this is especially true when accessing data. In this article, I’m going to spend some tim</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#8626535Fri, 20 Jun 2008 22:08:22 GMT91d46819-8472-40ad-a661-2c78acb4018c:8626535ADO.NET team blog<p>Background To set the stage for this article, do take a look at Exploring the Performance of the ADO.NET</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#8626643Fri, 20 Jun 2008 22:32:01 GMT91d46819-8472-40ad-a661-2c78acb4018c:8626643ADO.NET team blog<p>Background To set the stage for this article, do take a look at Exploring the Performance of the ADO.NET</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#8678030Tue, 01 Jul 2008 20:57:17 GMT91d46819-8472-40ad-a661-2c78acb4018c:8678030All Your Base Are Belong To Us<p>Concurrently with the finalization of the initial LINQ release bits, community previews of complementary</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#8853682Wed, 13 Aug 2008 00:20:44 GMT91d46819-8472-40ad-a661-2c78acb4018c:8853682Markus<p>Why does actual metadata information need to be retrieved from the database in runtime, taking 14% of the exec time (Initializing Metadata)? I thought the local metadata in all those XML files would be sufficient.</p> <p>I'm sure it serves a purpose, but I don't like the idea of burdening a production db server with metadata queries.</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#8883693Thu, 21 Aug 2008 09:38:08 GMT91d46819-8472-40ad-a661-2c78acb4018c:8883693Podlipensky<p>And what about the perfomance in last EF release? Does something changed?</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#8971529Wed, 01 Oct 2008 15:58:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:8971529eXcess<p>Yes, it would be interesting to know this for the latest EF release.</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#9306087Sun, 11 Jan 2009 20:39:58 GMT91d46819-8472-40ad-a661-2c78acb4018c:9306087Jiří {x2} Činčura<p>If we’ll skip exact details, we can say, that internal behavior of whole modeling and mapping is based</p> http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx#9538301Wed, 08 Apr 2009 17:43:26 GMT91d46819-8472-40ad-a661-2c78acb4018c:9538301Pietro Brambati Blog<p>Direi che una buona pagina da cui partire &#232; questo documento su MSDN :Performance Considerations for</p>