If you can't outspend a problem, out-think it
Quote
so you can see the difference there, you can overcome this problem with sheer horsepower. And money. We don't have that. So we have to be wise about about the way that we allocate the things that we do.
Episode 142: Bottom Funnel (episode page, opens in a new tab) 01:31:46 (play audio from this timestamp, opens in a new tab)
Speaker-labeled
Summary
Overcast can throw $5,000+ a month of hardware at aggregation; Podcast Index spends about $620 and aggregates four times as many feeds. So instead of costly real-time deletes that lock tables, a lightweight 'sweeper' cleans up later. That's fine 99% of the time, and the rare urgent case gets handled by email.
Also said
Episode 5: Episode 5 00:59:26 (play audio from this timestamp, opens in a new tab)
deleting things out of a database is expensive, too. Yeah, it's not free.
Voice-matched
Episode 6: Episode 6 01:09:05 (play audio from this timestamp, opens in a new tab)
you're going to end up doing a lot wasting a lot of space for podcasts that never get touched. And so I think a better way to do this is going to be to to respond to have it monitoring and respond when calls are made
Voice-matched
Episode 121: Lawful but Awful (episode page, opens in a new tab) 01:19:05 (play audio from this timestamp, opens in a new tab)
If if we had the budget to throw lots of money at a huge database instance, I would fix this with power.
Voice-matched