Thanks Phil. I'll keep a bookmark to this posting :-). Hopefully at some
point I'll have time and energy to further investigate this.
To test the theory, I had a go at updating my library, to convert
contributor_album artists to album artists, and contributor_track artists to
track artists, where they are associated with regular albums:
update contributor_track
set role=6
where role=1 and track in (
select t.id
from tracks as t
join albums as a on t.album = a.id
where a.compilation <> 1 and contributor_track.[track] = t.id
);
update contributor_album
set role=5
where role=1 and album in (
select a.id
from albums as a
where compilation <> 1 and contributor_album.[album] = a.id
);
You could probably add these lines to SQL/SQLite/schema_optimize.sql.
That script is run at the end of the scan process to run ANALYZE (it did
more than that in the past).
--
Michael
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
