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
--------------------
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
--------------------
I'm going to try removing Custom Scan to see if performance improves.
--
MeSue
Sue
http://www.last.fm/user/MeSue
------------------------------------------------------------------------
MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985
View this thread: http://forums.slimdevices.com/showthread.php?t=51894
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
