Inspired by a post on M.SU by studiohack, I'd like your thoughts on going through and cleaning up some of our old, unloved questions. I've taken a first pass at coming up with an SQL query (shamelessly stolen and adapted from the M.SU post) that shows some of these.
This query returns questions that have less than 50 views, no accepted answer, zero or one answers, and were last touched 180 days ago or more. For questions posted 12 months ago, having under 50 views is a good sign that they're not being picked up by the search-engines.
This is a fairly restrictive search. It can be expanded if we want, but I'm thinking these should be just expunged.
Good idea, or should we just leave things as they are?
Update: As I've gone through the query, I've noticed that a better metric is views-per-month. The stuff in the 6-7 month old range with 40-50 views still has some meat left on those bones. Roughly speaking, 5 vpm is about the breaking point of relevancy in the above list. I'll see if I can cobble together a query that'll do that.
Also Jeff Atwood has taken a well-aimed stab at making a query like this. His version:
Enable automatic deletion of old, unanswered zero-score questions after a year?