[mythtv-users] Slow program listings and deleting
Michael T. Dean
mtdean at thirdcontact.com
Wed May 16 14:32:40 UTC 2007
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
More information about the mythtv-users
mailing list