Search


	Podcast:		Full Stack Radio
	Episode:		104: Jonathan Reinink - Pushing More Work to the Database
	Category:		Technology
	Duration:		01:01:46
	Publish Date:		2018-12-19 10:16:00
	Description:		In this episode, Adam talks to Jonathan Reinink about strategies for off-loading resource intensive work from your application code and into your database. 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: Refactoring UI "Dynamic relationships in Laravel using subqueries" on Jonathan's blog Source code for Jonathan's Laracon Online talk The benefits of NOT EXISTS on StackOverflow Advanced Eloquent, Jonathan's Laravel package
	Total Play:		0

Users also like

200+ Episodes

A Grey Matte .. 50+ 4