more info : I did a "clear database" and renamed again a directory. This time the 20.000 updates ran in 9 seconds.
[11-08-20 11:07:21.8694] Plugins::TrackStat::Storage::deleteAllTracks (1888) TrackStat: *Clear all data finished at: 1313831241* [11-08-20 11:08:23.2456] Slim::Utils::Scanner::Local::rescan (166) Discovering files in [...] [11-08-20 11:08:34.3774] Plugins::TrackStat::Plugin::commandCallback65 (3882) Entering commandCallback65 [11-08-20 11:08:34.3780] Plugins::TrackStat::Storage::refreshTracks (1250) Starting to update urls in statistic data based on musicbrainz ids [11-08-20 11:08:34.4410] Plugins::TrackStat::Storage::refreshTracks (1329) Finished updating urls in statistic data based on musicbrainz ids, updated 0 items : It took 0.062832 seconds [11-08-20 11:08:34.4414] Plugins::TrackStat::Storage::refreshTracks (1343) Starting to update musicbrainz id's in statistic data based on urls [11-08-20 11:08:34.4420] Plugins::TrackStat::Storage::refreshTracks (1367) Finished updating musicbrainz id's in statistic data based on urls, updated 0 items : It took 0.000606 seconds [11-08-20 11:08:34.4423] Plugins::TrackStat::Storage::refreshTracks (1381) Starting to add tracks without added times in statistic data based on urls [11-08-20 11:08:43.8168] Plugins::TrackStat::Storage::refreshTracks (1413) Finished adding tracks without added times in statistic data based on urls, *added 22711 items : It took 9.374233 seconds* [11-08-20 11:08:43.8172] Plugins::TrackStat::Storage::refreshTracks (1419) Starting analyzing track_statistics table [11-08-20 11:08:43.9377] Plugins::TrackStat::Storage::refreshTracks (1421) Finished analyzing track_statistics table : It took 0.120026 seconds [11-08-20 11:08:43.9382] Plugins::TrackStat::Storage::refreshTracks (1427) Starting to update ratings in standard slimserver database based on urls [11-08-20 11:08:44.4310] Plugins::TrackStat::Storage::refreshTracks (1451) Finished updating ratings in standard slimserver database based on urls, updated 0 items : It took 0.492647 seconds [11-08-20 11:08:44.4314] Plugins::TrackStat::Storage::refreshTracks (1465) Starting to update added times in statistic data based on urls [11-08-20 11:08:48.7938] Plugins::TrackStat::Storage::refreshTracks (1489) Finished updating added times in statistic data based on urls, updated 818 items : It took 4.361922 seconds [11-08-20 11:08:48.7944] Plugins::TrackStat::Storage::refreshTracks (1495) Starting analyzing track_statistics table [11-08-20 11:08:48.8710] Plugins::TrackStat::Storage::refreshTracks (1497) Finished analyzing track_statistics table : It took 0.076499 seconds [11-08-20 11:08:48.8918] Plugins::TrackStat::Storage::refreshTracks (1503) Starting to update play counts in statistic data based on urls [11-08-20 11:08:50.1179] Plugins::TrackStat::Storage::refreshTracks (1533) Finished updating play counts in statistic data based on urls, updated 0 items : It took 1.226215 seconds [11-08-20 11:08:50.1183] Plugins::TrackStat::Storage::refreshTracks (1538) Starting to update last played times in statistic data based on urls [11-08-20 11:08:51.3250] Plugins::TrackStat::Storage::refreshTracks (1568) Finished updating last played times in statistic data based on urls, updated 0 items : It took 1.206458 seconds [11-08-20 11:08:51.3254] Plugins::TrackStat::Storage::refreshTracks (1582) Starting to update ratings in statistic data based on urls [11-08-20 11:08:51.7058] Plugins::TrackStat::Storage::refreshTracks (1610) Finished updating ratings in statistic data based on urls, updated 0 items : It took 0.380072 seconds [11-08-20 11:08:51.7062] Plugins::TrackStat::Storage::refreshTracks (1624) Starting to update unrated ratings in statistic data based on null [11-08-20 11:08:51.7339] Plugins::TrackStat::Storage::refreshTracks (1644) Finished updating unrated ratings in statistic data based on null, updated 0 items : It took 0.027515 seconds [11-08-20 11:08:51.7343] Plugins::TrackStat::Storage::refreshTracks (1659) Starting to update urls in track_history based on musicbrainz ids [11-08-20 11:08:51.7351] Plugins::TrackStat::Storage::refreshTracks (1683) Finished updating urls in track_history based on musicbrainz ids, updated 0 items : It took 0.000754 seconds [11-08-20 11:08:51.7354] Plugins::TrackStat::Storage::refreshTracks (1697) Starting to update musicbrainz id's in track_history based on urls [11-08-20 11:08:51.7361] Plugins::TrackStat::Storage::refreshTracks (1721) Finished updating musicbrainz id's in statistic data based on urls, updated 0 items : It took 0.000591 seconds [11-08-20 11:08:51.7364] Plugins::TrackStat::Storage::refreshTracks (1735) Starting to add missing entries to history table [11-08-20 11:08:56.3159] Plugins::TrackStat::Storage::refreshTracks (1755) Finished adding missing entries to history table, adding 1504 items : It took 4.579251 seconds [11-08-20 11:08:56.3163] Plugins::TrackStat::Storage::refreshTracks (1761) Starting analyzing track_history table [11-08-20 11:08:56.3272] Plugins::TrackStat::Storage::refreshTracks (1763) Finished analyzing track_history table : It took 0.010536 seconds [11-08-20 11:08:56.3278] Plugins::TrackStat::Storage::refreshTracks (1769) Starting to update unrated ratings in history table based on null [11-08-20 11:08:56.3303] Plugins::TrackStat::Storage::refreshTracks (1789) Finished updating unrated ratings in history table based on null, updated 0 items : It took 0.002356 seconds [11-08-20 11:08:56.3309] Plugins::TrackStat::Plugin::commandCallback65 (3898) Exiting commandCallback65 -- reniera ------------------------------------------------------------------------ reniera's Profile: http://forums.slimdevices.com/member.php?userid=40705 View this thread: http://forums.slimdevices.com/showthread.php?t=89719 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
