Play by Play: Database Tuning

Rob Sullivan tweaks the performance of a failing database using the Stack Overflow data dump.
Course info
Level
Intermediate
Updated
Jun 4, 2011
Duration
1h 4m
Table of contents
Description
Course info
Level
Intermediate
Updated
Jun 4, 2011
Duration
1h 4m
Description

In this single video, Rob Sullivan is tasked with perf-tuning an ASP.NET MVC 3 web application (using EF) so it can handle a StackOverflow data dump. Over 4 million rows of data in the Posts table alone! The application is one that any web developer might build - with holes in it that any developer might fall into. The site is timing out, we're down - we need some help from an amazing DBA!

About the author
About the author

Rob Conery co-founded Tekpub and created This Developer's Life. He is an author, speaker, and sometimes a little bit opinionated.

More from the author
PostgreSQL Playbook for Developer DBAs
Intermediate
2h 36m
Apr 5, 2016
Electron Playbook
Intermediate
1h 38m
Mar 2, 2016
More courses by Rob Conery
About the author

Rob is a bona fide Alpha Nerd. He is the Senior Data Magistrate for the government in the Prism division where he specializes in data collection and data profiling. When he isn’t lording over AppDevs and Architects, he can be found truncating vast amounts of pizza, ETLing burritos and breaking down the execution plans of video games.

More from the author
A Tour of PostgreSQL
Intermediate
2h 15m
Mar 26, 2012