[mythtv-users] Slow program listings and deleting

[Michael T. Dean]

On 05/16/2007 10:32 AM, Rob Willett (Mythtv) wrote:
> Bingo. This worked. It pulled my recordmatch table down to 136 rows from 
>   4012. The execution time is now 0.5 sec as opposed to 70 secs or so.
>
> I'll add this to my crontab file as well as the optimise_mythdb.pl.
>
> Many thanks for your help,

Glad you got it before you started deleting things/hacked your DB 
schema/other unsavory things...  :)

Mike