Full Stack Radio

{{ show.title }}Trailer Bonus Episode {{ selectedEpisode.number }}
{{ selectedEpisode.title }}
|
{{ displaySpeed }}x
{{ selectedEpisode.title }}
By {{ selectedEpisode.author }}
Broadcast by

Summary

In this episode, Adam talks to Jonathan Reinink about strategies for off-loading resource intensive work from your application code and into your database.

Show Notes

Topics include:
  • Issues you run into when you do too much work in code instead of in the database
  • Why memory usage is just as important as query count
  • How being smarter with your database usage can let you avoid hard problems like cache invalidation
  • Denormalizing computable data to make it queryable
  • Using "where not exists" strategically to improve query performance
  • Why the solution to n+1 problems isn't always as simple as eager-loading
  • How subqueries work and how you can use them to avoid memory problems when eager-loading
Sponsors:
  • Oh Dear!, sign up with the coupon code "FULLSTACKRADIO" to get 50% off your first month
  • Rollbar, sign up at https://rollbar.com/fullstackradio and install Rollbar in your app to receive a $100 gift card for Open Collective
Links:

What is Full Stack Radio?

A podcast for developers interested in building great software products. Every episode, Adam Wathan is joined by a guest to talk about everything from product design and user experience to unit testing and system administration.