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