[mythtv-users] query speedup?

[Michael T. Dean]

On 11/26/2006 09:19 AM, Michael T. Dean wrote:
> On 11/26/2006 07:03 AM, Udo van den Heuvel wrote:
>   
>> Udo van den Heuvel wrote:
>>   
>>     
>>> Mr. Myth wrote:
>>>     
>>>       
>>>> I had an issue once where there were shows in the database but no actual 
>>>> files in the recordings directory.  It made mythweb run incredibly slow 
>>>> while it repeatedly tried to open the files to generate thumbnails for them.
>>>>       
>>>>         
>>> There are indeed a few cases of the situation you describe.
>>> I can delete them in the listing but when I refresh the mythweb page
>>> showing the LiveTV recordings they re-appear and query time does not
>>> really change.
>>>     
>>>       
>> I manually deleted the entries from the recorded table in MySQL and the
>> query now runs much faster.
>> What remains is the question why the MythWeb delete action does not
>> work. (at least not when there is no mpg present)
>>     
>
> Don't use MythWeb.  Don't use mysql.  Use the frontend's Watch 
> Recordings/Delete Recordings screen to do the delete.  There's more to a 
> recording than just a row in the recorded table.
>   

Just thought I should clarify--the only reason not to delete using 
MythWeb is because the user above said MythWeb doesn't actually let the 
delete occur.  Deleting a normal show (i.e. with an existing recording 
file) through MythWeb is fine (or deleting a show without a file through 
MythWeb is fine if you can make it work).

Mike