[mythtv-users] query speedup?

[Michael T. Dean]

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.

Mike