@vandys I like the idea of a cron job to clean that up on a timer.
How much of a performance hit is it when you try to INSERT and there is an index collision. Is it basically like a NOOP, or is there still some overhead with that? Just not sure how much of a big deal it is to have all those inserts still colliding after I remove the ON DUPLICATE KEY UPDATE purge=0 clause.
Intended for all stake holders of podcasting who are interested in improving the eco system