The Pod Sage

Dave Jones, collected

Wisdom

Index properly up front; retrofitting is a big lift

that is the one thing I regret about the NFA items table, which is the episodes table that I did not index properly. I did not index the the type the media type properly.

Episode 42: we're all a flutter. Yeah, it's Friday, you know what that means? Time for a mee (approx., from transcript intro) 01:46:59

Voice-matched

Summary

Filtering the Podcast Index's episodes table by audio or video required an index on media type that Dave never added. With 70 million rows, adding one later is a big lift: test on a dev copy, and possibly stop all writes and shut the aggregators down for hours.

Not in the audio. 'NFA' is the transcript's rendering of the table name.