MrD wrote:
>
> I was having a issue with restarts and rescans of my server taking 90
> minutes to 2 hours on a 20k library with TrackStat enabled.
>
The temp table will be empty unless you have moved/renamed music files
and dont have multiple files with the same musicbrainz id. So if an
index i temp table solves the issue it might be an indication of:
1. You have moved or renamed a lot of files since last refresh and the
refresh does its thing and reconnect statistics to the new/changed
files
Or
2. You have multiple files with same musicbrainz id and in this case the
refresh operation will duplicate the entries for these files in
track_statistics table every time refresh runs due to a bug in refresh
logic. Typical scenario when you might have multiple tracks with same
musicbrainz id is when a track exist both in a normal album and in a
compilation album.
If it isnt caused by 1 you are likely affected by 2 and in this case
Id strongly recommend either removing musicbrainz tags from the files
that exist in several places in your library or disable musicbrainz
support in TrackStat settings. Multiple entries for same track in
track_statistic table will otherwise cause unpredictable behavior for
these tracks and its going to get worse every time TrackStat refresh
operation runs.
Having said this, the TrackStat refresh operation can be slow due to
other things than musicbrainz, its possible to see in server.log which
parts of refresh that take long time if enabling info level debugging on
plugin.trackstat.
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
Developer of 'many plugins/applets'
(https://wiki.slimdevices.com/index.php/User_Erland.html)
*Starting with LMS 8.0 I no longer support my plugins/applets* ('see
here for more information'
(https://forums.slimdevices.com/showthread.php?49483-Announce-New-versions-of-erlands-plugins&p=998836&viewfull=1#post998836)
)
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
