Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Query Auditing and Performance1:47 with James Churchill
Let's start with an overview of application auditing and what we'll be covering in this workshop.
Comic Book Library Manager Web App
The Comic Book Library Manager web app can be viewed at http://comic-book-library-manager.azurewebsites.net/.
The project files for the Comic Book Library Manager web app are available at http://treehouse-project-downloads.s3.amazonaws.com/dotnet-ef-with-aspnet-mvc-comic-book-library-manager-completed.zip.
.NET Logging Libraries
Here are some of the popular .NET logging libraries that are available.
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.
You need to sign up for Treehouse in order to download course files.Sign up