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.