Query Auditing and Performance

[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