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
_______________________________________________
mythtv-dev mailing list
mythtv-dev@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-dev
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
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
_______________________________________________
mythtv-dev mailing list
mythtv-dev@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-dev
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org