104: Jonathan Reinink - Pushing More Work to the Database
source link: https://share.transistor.fm/s/abe63742
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Full Stack Radio
Episode Details
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
- 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
- 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
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.
All audio, artwork, episode descriptions and notes are property of Adam Wathan, for Full Stack Radio, and published with permission by Transistor, Inc.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK