id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
2958	Database cleanup in MythMusic	otto at kolsi dot fi	stuartm	"MythMusic does not clean album, artist or genre tables and thus if songs are removed, there is a good change that the database starts to grow up because there are left-overs in album, artist and genre tables.

Attached patch adds database cleanup to MythMusic. Cleanup deletes rows from the music_genres, music_albums and music_artists that are now longer ""linked"" to any song in music_songs.

This cleanup is performed only when songs are removed from the DB and not everytime songs are re-scanned. This is because cleanup operation might take a while if you have large collection and/or slow machine.

This means that if you only add or modify songs, DB is never cleaned. It this needs to be addressed, maybe a manual action/task could be added to the MusicTools menu."	enhancement	closed	minor	0.21	mythmusic	head	medium	fixed			0