Database Reference
In-Depth Information
Chapter 13
Improving Performance
The recipes in this chapter cover a wide range of specific ways to improve the performance of your Entity Framework
applications. In many cases, simple changes to a query or to the model, or even pushing startup overhead to a
different part of application, can significantly improve some aspect of your application's performance.
13-1. Optimizing Queries in a Table per Type Inheritance Model
Problem
You want to improve the performance of a query in a model with Table per Type inheritance.
Solution
Let's say that you have a simple Table per Type inheritance model, like the one shown in Figure
13-1
.
Figure 13-1.
A simple Table per Type inheritance model for Salaried and Hourly employees