mythfrontend release34 watch videos

Post Reply
davesliving
Newcomer
Posts: 2
Joined: Tue Feb 27, 2024 12:07 pm
United States of America

mythfrontend release34 watch videos

Post by davesliving »

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.
If this is not the correct place for reporting these types of issues, let me know where for future reference.
Thanks
Dave
User avatar
pgbennett
Developer
Posts: 510
Joined: Mon Apr 27, 2015 5:41 pm
United States of America

Re: mythfrontend release34 watch videos

Post by pgbennett »

Open an issue in github at https://github.com/MythTV/mythtv/issues with the details.
davesliving
Newcomer
Posts: 2
Joined: Tue Feb 27, 2024 12:07 pm
United States of America

Re: mythfrontend release34 watch videos

Post by davesliving »

Last edited by Steve Goodey on Tue Feb 27, 2024 4:05 pm, edited 1 time in total.
Reason: URL amended.
Post Reply