[mythtv] Database version update

Peter Bennett pb.mythtv at gmail.com
Wed Jul 1 19:35:15 UTC 2020


I plan to update the database version in master to 1363, to add an index 
to recordedartwork.

The /Dvr/GetRecordedList service takes 45 seconds on my prod system. 
This change reduces it to 5 seconds. recordedartwork has no index and 
the /Dvr/GetRecordedList searches recordedartwork multiple times during 
execution.

CREATE INDEX recordedartwork_ix1 ON recordedartwork (inetref);

Anybody have any issues with that?

Peter





More information about the mythtv-dev mailing list