A separate table per item type means more database locking
Quote
The one, um, the one drawback to having separate tables per sort of like a item type is you tend to have more locking, you know, database locking as things cause, cause that updating or deleting content in one table since you have just tons of linkage across tables
Episode 246: Crap Trap (episode page, opens in a new tab) 01:04:15 (play audio from this timestamp, opens in a new tab)
Voice-matched
Summary
Reviewing Podverse's new schema with a separate table for every Podcasting 2.0 tag type, Dave flags the trade-off. All the linkage across tables means updates and deletes in one table ripple outward, causing more database locking. Proper indexing alone may not solve it.
Not in the audio. Guest episode (Mitch Downey and Archie of Podverse; 0.35 voice threshold). Dave is the one questioning their schema here; the 7-cue Dave run asks them 'Have you seen any of those kinds of' issues.