This chapter is the first of three addressing performance-tuning your database accesses. Covering what to improve, as well as where and how to improve your EF Core database code, this chapter is divided into three parts:
- Part 1 —Understanding performance, the difference between speed and scalability, deciding what to performance-tune, and determining the costs of performance tuning
- Part 2 —Techniques you can use to find performance issues and the use of EF Core’s logging to help you spot problems
- Part 3 —A whole range of database access patterns, both good and bad, to help you diagnose and fix many EF Core performance issues
In chapter 15, you’ll apply the approaches shown in this chapter to the Book App’s book list query. You’ll start by tuning EF Core code and then progress to more complex techniques, such as adding SQL commands to squeeze the best performance out of the database accesses.