You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Long time mythtv user, new to forum. Really appreciate the work that's been done to keep mythtv moving forward.
I just updated to v34 in support of a nodejs express web client I've been working on.
The issue I encountered is when I use the mythtv-frontend and go to "Media Library/Watch Videos". I get a significant pause before seeing anything. I monitored mysql and saw the following statement being run for the duration of the pause:
SELECT filename, type, mark, offset FROM filemarkup WHERE type IN (2, 34, 41) ORDER BY filename
I have ~12M rows in the fielmarkup table.
By adding a new index for type to filemarkup, the screen loads quickly.
How often does it reproduce? Is there a required condition?
Everytime.
What is the expected behaviour?
What do you see instead?
Additional information
The text was updated successfully, but these errors were encountered:
Platform: Ubuntu
MythTV version: 34
Package version:
Component: Myth Frontend
What steps will reproduce the bug?
Long time mythtv user, new to forum. Really appreciate the work that's been done to keep mythtv moving forward.
I just updated to v34 in support of a nodejs express web client I've been working on.
The issue I encountered is when I use the mythtv-frontend and go to "Media Library/Watch Videos". I get a significant pause before seeing anything. I monitored mysql and saw the following statement being run for the duration of the pause:
SELECT filename, type, mark,
offset
FROM filemarkup WHERE type IN (2, 34, 41) ORDER BY filenameI have ~12M rows in the fielmarkup table.
By adding a new index for type to filemarkup, the screen loads quickly.
How often does it reproduce? Is there a required condition?
Everytime.
What is the expected behaviour?
What do you see instead?
Additional information
The text was updated successfully, but these errors were encountered: