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.
[MUSIC] 0:00 The scheduled launch date for our web app is rapidly approaching. 0:04 We've worked hard to implement all of our user's required features, and 0:08 user acceptance testing is finally in full swing. 0:12 But unfortunately, our test users are complaining about the performance of some 0:15 key pages in our web app. 0:20 The problem is bad enough that everyone involved has 0:22 decided that it needs to be resolved before we can go live. 0:25 It’s very common for every web app regardless of its size or 0:28 perceived complexity to require some additional tweaking or fine tuning. 0:32 Before attempting to resolve any performance related issue, 0:37 it’s important to have a full understanding of the problem. 0:40 To do this requires having the ability to adequately audit each part of our web app. 0:43 There are any number of ways to audit your web app, 0:49 including adding logging statements to key functions, profiling your app using 0:52 the tools available within Visual Studio, or even manually stepping through code. 0:56 All of these approaches are valid and sometimes you'll find yourself using 1:01 every tool at your disposal in order to diagnose an issue. 1:05 In this workshop we'll see how to audit entity framework queries 1:09 within the context of ASP.NET and 1:12 VC Web App and how to address some common query performance issues. 1:14 As we learn about EF query performance, 1:19 we'll work with a comic book library manager web app. 1:21 This ASP.NET MVC web app allows users to manage a digital library of 1:24 comic books by giving them tools for creating, updating, and 1:29 deleting comic books, series, and artists. 1:33 To follow along with this workshop, see the teacher's notes for 1:37 a link to download the project files. 1:39 Next up we'll install a tool called Glimpse and 1:42 use it to audit our EF queries. 1:44
You need to sign up for Treehouse in order to download course files.Sign up