[mythtv-users] Slow program listings and deleting

[Michael T. Dean]

On 05/16/2007 10:20 AM, Rob Willett (Mythtv) wrote:
> Nick Morrott wrote:
>   
>>> 4) Does the monster SQL statement above look familiar? Does it have form
>>> as a slow query? Are there additional indexes that could be created? I
>>> did an EXPLAIN on it, but it doesn't give me any real help.
>>>       
>> You can check http://cvs.mythtv.org/trac/browser/trunk/mythtv/libs/libmythtv/dbcheck.cpp
>> and cross-reference your installation's DBSchema version to ensure you
>> have the intended indexes - if you have any missing you can recreate
>> them.
> Thats the sort of thing I was after. I've had a look and will see if I 
> can compare this to my schema.
>   

If you hack your DB, future updates will fail (i.e. you won't be able to 
upgrade your MythTV version without a /lot/ of workaround - 
http://www.gossamer-threads.com/lists/mythtv/users/223625#223625 , steps 
A-Z).  If you want the trunk indexes, upgrade to trunk (and sign up for, 
and read all messages on, the -dev and -commits lists).  However, 
there's likely no need (and chances are you'll get the same issues with 
trunk).

I still think that rather than deleting rules/channels/data or hacking 
the DB, you just need to let Myth do its job...

Mike