MeSue;335966 Wrote: > Here's the Database Query result: > > > Code: -------------------- > > parameter;value > Number of song attributes;181620 > Number of artist attributes;0 > Number of album attributes;0 > Number of songs with attributes;17366 > Number of songs without attributes;0 > Number of artists with attributes;0 > Number of artists without attributes;992 > Number of albums with attributes;0 > Number of albums without attributes;1355 > Number of songs with attributes from customtag;8602 > Number of songs with attributes from mixedtag;17366 > Number of songs with attributes from ratingtag;7724 > Number of song attributes from customtag;98324 > Number of song attributes from mixedtag;75572 > Number of song attributes from ratingtag;7724 > Number of songs without attributes from customtag;8764 > Number of songs without attributes from mixedtag;0 > Number of albums without attributes from csamazon;1355 > Number of artists without attributes from cslastfm;992 > Number of songs with customtag attributes of type COMMENT;8602 > Number of songs with mixedtag attributes of type ALBUM;17366 > Number of songs with mixedtag attributes of type ALBUMARTIST;2729 > Number of songs with mixedtag attributes of type ARTIST;17366 > Number of songs with mixedtag attributes of type COMPOSER;586 > Number of songs with mixedtag attributes of type GENRE;17366 > Number of songs with mixedtag attributes of type TRACKARTIST;2729 > Number of songs with mixedtag attributes of type YEAR;17366 > Number of songs with ratingtag attributes of type RATING;7724 -------------------- > > > Nothing strange there as far as I can see
MeSue;335966 Wrote: > > Here's what was in the log after running trackstat refresh: > > Code: -------------------- > > > [08-09-02 21:32:17.1782] Slim::Web::Settings::handler (153) Preference names must be prefixed by "pref_" in the page template: backup_file (PLUGIN_TRACKSTAT_SETTINGS_BACKUP) > [08-09-02 21:32:17.1793] Slim::Web::Settings::handler (153) Preference names must be prefixed by "pref_" in the page template: backup_dir (PLUGIN_TRACKSTAT_SETTINGS_BACKUP) > [08-09-02 21:32:17.1802] Slim::Web::Settings::handler (153) Preference names must be prefixed by "pref_" in the page template: backup_time (PLUGIN_TRACKSTAT_SETTINGS_BACKUP) > [08-09-02 21:32:17.2677] Plugins::TrackStat::Storage::refreshTracks (1089) Checking if additional indexes are needed for tracks > [08-09-02 21:32:19.0788] Plugins::TrackStat::Storage::refreshTracks (1113) Starting to analyze indexes > [08-09-02 21:32:19.7504] Plugins::TrackStat::Storage::refreshTracks (1126) Finished analyzing indexes : It took 2.483006 seconds > [08-09-02 21:32:19.7508] Plugins::TrackStat::Storage::refreshTracks (1131) Starting to update urls in statistic data based on musicbrainz ids > [08-09-02 21:32:19.8011] Plugins::TrackStat::Storage::refreshTracks (1150) Finished updating urls in statistic data based on musicbrainz ids, updated 0 items : It took 0.050079 seconds > [08-09-02 21:32:19.8015] Plugins::TrackStat::Storage::refreshTracks (1155) Starting to update musicbrainz id's in statistic data based on urls > [08-09-02 21:32:20.5629] Plugins::TrackStat::Storage::refreshTracks (1175) Finished updating musicbrainz id's in statistic data based on urls, updated 0 items : It took 0.761193 seconds > [08-09-02 21:32:20.5636] Plugins::TrackStat::Storage::refreshTracks (1180) Starting to update ratings in standard slimserver database based on urls > [08-09-02 21:32:27.7663] Plugins::TrackStat::Storage::refreshTracks (1200) Finished updating ratings in standard slimserver database based on urls, updated 0 items : It took 7.202306 seconds > [08-09-02 21:32:27.7671] Plugins::TrackStat::Storage::refreshTracks (1205) Starting to update added times in statistic data based on urls > [08-09-02 21:32:35.8131] Plugins::TrackStat::Storage::refreshTracks (1225) Finished updating added times in statistic data based on urls, updated 0 items : It took 8.045812 seconds > [08-09-02 21:32:35.8139] Plugins::TrackStat::Storage::refreshTracks (1230) Starting to update play counts in statistic data based on urls > [08-09-02 21:32:48.0159] Plugins::TrackStat::Storage::refreshTracks (1254) Finished updating play counts in statistic data based on urls, updated 0 items : It took 12.202116 seconds > [08-09-02 21:32:48.0168] Plugins::TrackStat::Storage::refreshTracks (1259) Starting to update last played times in statistic data based on urls > [08-09-02 21:33:02.2506] Plugins::TrackStat::Storage::refreshTracks (1283) Finished updating last played times in statistic data based on urls, updated 0 items : It took 14.233643 seconds > [08-09-02 21:33:02.2515] Plugins::TrackStat::Storage::refreshTracks (1288) Starting to add tracks without added times in statistic data based on urls > [08-09-02 21:33:12.6725] Plugins::TrackStat::Storage::refreshTracks (1312) Finished adding tracks without added times in statistic data based on urls, added 0 items : It took 10.420868 seconds > [08-09-02 21:33:12.6733] Plugins::TrackStat::Storage::refreshTracks (1317) Starting to update ratings in statistic data based on urls > [08-09-02 21:33:16.9538] Plugins::TrackStat::Storage::refreshTracks (1341) Finished updating ratings in statistic data based on urls, updated 0 items : It took 4.280239 seconds > [08-09-02 21:33:16.9545] Plugins::TrackStat::Storage::refreshTracks (1346) Starting to update unrated ratings in statistic data based on null > [08-09-02 21:33:17.4092] Plugins::TrackStat::Storage::refreshTracks (1366) Finished updating unrated ratings in statistic data based on null, updated 0 items : It took 0.454719 seconds > [08-09-02 21:33:17.4096] Plugins::TrackStat::Storage::refreshTracks (1372) Starting to update urls in track_history based on musicbrainz ids > [08-09-02 21:33:17.7347] Plugins::TrackStat::Storage::refreshTracks (1392) Finished updating urls in track_history based on musicbrainz ids, updated 0 items : It took 0.32493 seconds > [08-09-02 21:33:17.7352] Plugins::TrackStat::Storage::refreshTracks (1397) Starting to update musicbrainz id's in track_history based on urls > [08-09-02 21:33:19.2347] Plugins::TrackStat::Storage::refreshTracks (1417) Finished updating musicbrainz id's in statistic data based on urls, updated 0 items : It took 1.499405 seconds > [08-09-02 21:33:19.2354] Plugins::TrackStat::Storage::refreshTracks (1422) Starting to add missing entries to history table > [08-09-02 21:33:30.6881] Plugins::TrackStat::Storage::refreshTracks (1442) Finished adding missing entries to history table, adding 0 items : It took 11.452458 seconds > [08-09-02 21:33:30.6889] Plugins::TrackStat::Storage::refreshTracks (1447) Starting to update unrated ratings in history table based on null > [08-09-02 21:33:30.7022] Plugins::TrackStat::Storage::refreshTracks (1467) Finished updating unrated ratings in history table based on null, updated 0 items : It took 0.013048 seconds > -------------------- > > > A bit slower than normal but not close to the performance decrease you saw in the corresponding Custom Scan refresh operation. MeSue;335986 Wrote: > So far so good. I removed Custom Scan and did a rescan for changes and > there was no bog down during or after it. > The TrackStat refresh seemed a bit long to and that also happens after rescan, but hopefully its fast enough so the Squeezebox buffering is able to compensate for it. There is two option in "SqueezeCenter Settings/Plugins/TrackStat" called "Startup refresh" and "Rescan refresh" which can be used to disable the TrackStat refresh operation. So if you get problems due to the TrackStat refresh, you can use these options to disable it. The consequence of disabling it is that you will loose statistics and ratings for a track if you rename or move any music file. If you don't have musicbrainz tags in your music, you will always loose the statistics and rating when moving/renaming files independent if the refresh operation is active or not. MeSue;335986 Wrote: > > I don't think I even needed Custom Scan for what I thought I did > anyway. I was doing some SQL playlists based on keywords. My Music > Manager puts custom tags into the comment tag. I thought I needed > Custom Scan to pick up those keywords, but I guess the comment field is > picked up with a standard scan because my SQL playlist still works. > Comment field is picked up by standard SqueezeCenter scanning. >From the statistics you shown it looked like you had data in the "Rating Tag" scanning module use to retrieve ratings from tags, if this is something you use you probably just want to disable and clear the "Custom Tag" and "Mixed Tag" scanning modules. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=51894 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
