[mythtv] Housekeeping of the program table

[Michael T. Dean]

On 09/16/06 14:49, usleepless at gmail.com wrote:

>i have been strugling to get the scheduler-query in 0.18-fixes perform better.
>
>however, my attention was drawn to the data in the program-table. it
>dates back to when i started using mythtv. so i have 8-months worth of
>program-guide.
>
>how is this supposed to be handled? is there a housekeeping procedure
>which should run, but is not running in my build?
>
>is it normal to retain all acquired program info?
>

No.  Program listing data for a show is deleted once the show airs (or a 
week after the shows have aired if you pass the "--no-delete" argument) 
by mythfilldatabase.  If your listing data isn't being deleted, you're 
either a) not running mythfilldatabase or b) you have a broken 
grabber/invalid video source configuration that's causing 
mythfilldatabase to fail before doing cleanup (but after adding new 
programs to the database--oh, and this can cause much more serious 
problems in 0.18 or 0.19 than just "dirty" program tables).  In 
0.19-fixes, the second case is handled nicely (but you shouls still fix 
it), but no matter how you get listings data into MythTV, you /must/ run 
mythfilldatabase in 0.18*, 0.19*, 0.20*, and SVN trunk versions.

Your scheduler query will definitely work much better once you fix the 
problem.

BTW, this is a -users question.

Mike