1 00:00:00,000 --> 00:00:04,745 [MUSIC] 2 00:00:04,745 --> 00:00:08,293 The scheduled launch date for our web app is rapidly approaching. 3 00:00:08,293 --> 00:00:12,785 We've worked hard to implement all of our user's required features, and 4 00:00:12,785 --> 00:00:15,859 user acceptance testing is finally in full swing. 5 00:00:15,859 --> 00:00:20,707 But unfortunately, our test users are complaining about the performance of some 6 00:00:20,707 --> 00:00:22,191 key pages in our web app. 7 00:00:22,191 --> 00:00:25,403 The problem is bad enough that everyone involved has 8 00:00:25,403 --> 00:00:28,989 decided that it needs to be resolved before we can go live. 9 00:00:28,989 --> 00:00:32,569 It’s very common for every web app regardless of its size or 10 00:00:32,569 --> 00:00:37,159 perceived complexity to require some additional tweaking or fine tuning. 11 00:00:37,159 --> 00:00:40,194 Before attempting to resolve any performance related issue, 12 00:00:40,194 --> 00:00:43,740 it’s important to have a full understanding of the problem. 13 00:00:43,740 --> 00:00:48,240 To do this requires having the ability to adequately audit each part of our web app. 14 00:00:49,280 --> 00:00:52,140 There are any number of ways to audit your web app, 15 00:00:52,140 --> 00:00:56,360 including adding logging statements to key functions, profiling your app using 16 00:00:56,360 --> 00:01:01,580 the tools available within Visual Studio, or even manually stepping through code. 17 00:01:01,580 --> 00:01:05,310 All of these approaches are valid and sometimes you'll find yourself using 18 00:01:05,310 --> 00:01:09,020 every tool at your disposal in order to diagnose an issue. 19 00:01:09,020 --> 00:01:12,460 In this workshop we'll see how to audit entity framework queries 20 00:01:12,460 --> 00:01:14,620 within the context of ASP.NET and 21 00:01:14,620 --> 00:01:19,710 VC Web App and how to address some common query performance issues. 22 00:01:19,710 --> 00:01:21,860 As we learn about EF query performance, 23 00:01:21,860 --> 00:01:24,840 we'll work with a comic book library manager web app. 24 00:01:24,840 --> 00:01:29,310 This ASP.NET MVC web app allows users to manage a digital library of 25 00:01:29,310 --> 00:01:33,420 comic books by giving them tools for creating, updating, and 26 00:01:33,420 --> 00:01:37,200 deleting comic books, series, and artists. 27 00:01:37,200 --> 00:01:39,870 To follow along with this workshop, see the teacher's notes for 28 00:01:39,870 --> 00:01:42,150 a link to download the project files. 29 00:01:42,150 --> 00:01:44,930 Next up we'll install a tool called Glimpse and 30 00:01:44,930 --> 00:01:46,750 use it to audit our EF queries.