[mythtv-users] Slow program listings and deleting

[Rob Willett (Mythtv)]

Mike,

I got the first message and replied to that before your message. The 
mythfilldatabase --no-delete worked a treat. Well I think it did, I'm 
putty'ed in from work and so only have command line access, but the 
dodgy large query runs in no time at all now and the recordmatch table 
size is down to something sensible.

I'll look at the schema, but just for information purposes. How's it all 
link together.

Thanks again for your help and advice.

Rob.

Michael T. Dean wrote:
> 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
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users