8.9. Performance
The EF team has fine-tuned the performance of EF. One area that was improved is query generation. Previously, parameter length was passed into queries. This was a bad decision; parameters could vary in length, which would prevent SQL Server from utilizing the query cache. In EF4 parameter length is no longer passed, so the query cache can be utilized. The team has also tweaked how joins are made and removed unnecessary IsNull() calls.
Get Introducing .NET 4.0: with Visual Studio 2010 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
