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.