i've talked about this in the dev area, i have solved this with adding a filesize table to the presistent dbs and modifying the query to not only compare the musicbrainz_id instead compare also the filesize
the cause of this long running trackstat task, are duplicate musicbrain ids which might happen if you have multiple releases of the same album (example). My solution isn't ready for primetime, as the filesize table add is only for db creation atm, so someone has to delete persistent.db first, to make this work. current solution can be found here: https://github.com/mamema/lms-trackstat/tree/master/src modified files are dbcreate.sql and Storage.pm the current pain is solved, as the several hour run came down to 6 secs. Additionally the plugin LMS DB Optimizer does also help: https://www.nexus0.net/pub/sw/lmsdboptim/ ------------------------------------------------------------------------ mamema's Profile: http://forums.slimdevices.com/member.php?userid=44662 View this thread: http://forums.slimdevices.com/showthread.php?t=49483 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
