[mythtv] Database version update

Stuart Auchterlonie stuarta at squashedfrog.net
Thu Jul 2 09:47:21 UTC 2020


On 01/07/2020 20:35, Peter Bennett wrote:
> 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
> 
> 

Nope

Stuart


More information about the mythtv-dev mailing list