[mythtv-users] query speedup?

[Udo van den Heuvel]

Mr. Myth wrote:
> Udo van den Heuvel wrote:
>> Where can I find tips to speed up the database of MythTV?
>> MySQL takes 90+ seconds to list Recorded programs in MythWeb. (only 92
>> programs from 1 channel)
>> The machine is ~50% idle during the query.
>> How can I find out why this query takes so much time?
>>   
> 
> Have you looked in the mythbackend.log for errors while you use mythweb?
> 
> 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.
Is this a setup problem?