[MUSIC]

The scheduled launch date for our web app is rapidly approaching.

We've worked hard to implement all of our user's required features, and

user acceptance testing is finally in full swing.

But unfortunately, our test users are complaining about the performance of some

key pages in our web app.

The problem is bad enough that everyone involved has

decided that it needs to be resolved before we can go live.

It’s very common for every web app regardless of its size or

perceived complexity to require some additional tweaking or fine tuning.

Before attempting to resolve any performance related issue,

it’s important to have a full understanding of the problem.

To do this requires having the ability to adequately audit each part of our web app.

There are any number of ways to audit your web app,

including adding logging statements to key functions, profiling your app using

the tools available within Visual Studio, or even manually stepping through code.

All of these approaches are valid and sometimes you'll find yourself using

every tool at your disposal in order to diagnose an issue.

In this workshop we'll see how to audit entity framework queries

within the context of ASP.NET and

VC Web App and how to address some common query performance issues.

As we learn about EF query performance,

we'll work with a comic book library manager web app.

This ASP.NET MVC web app allows users to manage a digital library of

comic books by giving them tools for creating, updating, and

deleting comic books, series, and artists.

To follow along with this workshop, see the teacher's notes for

a link to download the project files.

Next up we'll install a tool called Glimpse and

use it to audit our EF queries.