[mythtv-users] 0.19 SQL tables accumulating too much data?

[chris at cpr.homelinux.net]

I'm using 0.19.  When I was looking through the "previously 
recorded" list yesterday I noticed that Myth is putting a lot of 
stuff in there that probably doesn't need to be there.  
Specifically, if I have ever recorded a show in the past, then 
EVERY SINGLE TIME it is rebroadcast Myth adds another copy to the 
"previously recorded" list.  Here's a sample from the "oldrecorded" 
table for "Holmes on Homes":

mysql> select subtitle, count(*) from oldrecorded where title like 
"Holmes%" group by subtitle having count(*) > 1 order by count(*) 
desc;
+----------------------+----------+
| subtitle             | count(*) |
+----------------------+----------+
| Twice Bitten         |        7 |
| Sweet Home Abandoned |        6 |
| Unfinished Business  |        5 |
| Wash & Weep          |        4 |
| Sight Unseen         |        4 |
| Additional Grief     |        4 |
| House 2 Home         |        3 |
| Ramp Revamp          |        2 |
| Hullaba-loo          |        2 |
| Terrible Terrace     |        2 |
| Flooded Foundation   |        2 |
| Garage Grievance     |        2 |

and so on.  Obviously I didn't record "Twice Bitten" 7 times.  It's 
simply been broadcast 6 more times since I first recorded it.

Is this really neccessary, or should there be a garbage-collection 
task that cleans out this stuff?