[mythtv-users] query speedup?
Michael T. Dean
mtdean at thirdcontact.com
Sun Nov 26 14:19:37 UTC 2006
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.
More information about the mythtv-users