mherger wrote: > >> Ugh... almost 10mins in the "Get changed tracks count" step... that > >> sounds utterly wrong :-(. At least now I know what to investigate > >> further. > > Ok, there's a new build (1400061520) which reverts a minor accidental > change in that query. I'd be surprised if that was responsible for the > poor performance you're seeing. But please give it a try. Thanks a lot! > > -- > > Michael
I gave it my best shot ... but it didn't help. Code: -------------------- [14-05-14 11:40:57.6316] main::main (202) Starting Logitech Media Server scanner (v7.9.0, 1400061520, Wed May 14 10:27:08 CUT 2014) perl 5.014001[14-05-14 11:40:58.2506] Slim::Schema::forceCommit (2109) Warning: Trying to commit transactions before DB is initialized! [14-05-14 11:40:58.6950] Slim::Music::Import::runImporter (479) Starting Slim::Media::MediaFolderScan scan [14-05-14 11:40:58.6964] Slim::Utils::Scanner::Local::rescan (177) Discovering audio files in L:\Squeezebox Music [14-05-14 11:41:39.7021] Slim::Utils::Scanner::Local::__ANON__ (191) Start processing found tracks [14-05-14 11:41:39.7027] Slim::Utils::Scanner::Local::__ANON__ (199) Connect do DB [14-05-14 11:41:39.7031] Slim::Utils::Scanner::Local::__ANON__ (202) Get latest ID [14-05-14 11:41:39.7037] Slim::Utils::Scanner::Local::__ANON__ (224) Delete temporary table if exists [14-05-14 11:41:39.7041] Slim::Utils::Scanner::Local::__ANON__ (227) Re-build temporary table [14-05-14 11:41:40.0297] Slim::Utils::Scanner::Local::__ANON__ (262) Get deleted tracks count [14-05-14 11:41:40.3466] Slim::Utils::Scanner::Local::__ANON__ (269) Get new tracks count [14-05-14 11:41:40.3472] Slim::Utils::Scanner::Local::__ANON__ (274) Get changed tracks count [14-05-14 11:51:05.4276] Slim::Utils::Scanner::Local::__ANON__ (280) Removing deleted audio files (0) [14-05-14 11:51:05.4288] Slim::Utils::Scanner::Local::__ANON__ (358) Scanning new audio files (0) [14-05-14 11:51:05.4290] Slim::Utils::Scanner::Local::__ANON__ (438) Rescanning changed audio files (0) [14-05-14 11:51:05.4294] Slim::Music::Import::endImporter (611) Completed Slim::Media::MediaFolderScan Scan in 606 seconds. [14-05-14 11:51:05.4590] Slim::Music::Import::runImporter (479) Starting Slim::Music::PlaylistFolderScan scan [14-05-14 11:51:05.4602] Slim::Utils::Scanner::Local::rescan (177) Discovering audio files in L:\Playlists [14-05-14 11:51:05.4996] Slim::Utils::Scanner::Local::__ANON__ (191) Start processing found tracks [14-05-14 11:51:05.5000] Slim::Utils::Scanner::Local::__ANON__ (199) Connect do DB [14-05-14 11:51:05.5003] Slim::Utils::Scanner::Local::__ANON__ (202) Get latest ID [14-05-14 11:51:05.5007] Slim::Utils::Scanner::Local::__ANON__ (224) Delete temporary table if exists [14-05-14 11:51:05.5011] Slim::Utils::Scanner::Local::__ANON__ (227) Re-build temporary table [14-05-14 11:51:05.6147] Slim::Utils::Scanner::Local::__ANON__ (262) Get deleted tracks count [14-05-14 11:51:05.6151] Slim::Utils::Scanner::Local::__ANON__ (269) Get new tracks count [14-05-14 11:51:05.6155] Slim::Utils::Scanner::Local::__ANON__ (274) Get changed tracks count [14-05-14 11:51:05.6340] Slim::Utils::Scanner::Local::__ANON__ (280) Removing deleted audio files (0) [14-05-14 11:51:05.6344] Slim::Utils::Scanner::Local::__ANON__ (358) Scanning new audio files (0) [14-05-14 11:51:05.6347] Slim::Utils::Scanner::Local::__ANON__ (438) Rescanning changed audio files (0) [14-05-14 11:51:05.6356] Slim::Music::Import::runImporter (479) Starting Plugins::SmartMix::Importer scan [14-05-14 11:51:05.6954] Slim::Music::Import::endImporter (611) Completed Plugins::SmartMix::Importer Scan in 0 seconds. [14-05-14 11:51:05.7255] Slim::Music::Import::runImporter (479) Starting Plugins::MusicArtistInfo::Importer scan [14-05-14 11:51:06.2372] Plugins::MusicArtistInfo::Importer::_getAlbumCoverURL (207) getAlbumCoverURL finished in 0.499167203903198 [14-05-14 11:51:10.0022] Plugins::MusicArtistInfo::Importer2::_getArtistPhotoURL (128) getArtistPhotoURL finished in 3.71163201332092 [14-05-14 11:51:10.1233] Slim::Music::Artwork::updateStandaloneArtwork (204) Starting updateStandaloneArtwork for 1 albums [14-05-14 11:51:10.2563] Slim::Music::Artwork::__ANON__ (302) updateStandaloneArtwork finished in 0.128326177597046 [14-05-14 11:51:10.3106] Slim::Music::Artwork::precacheAllArtwork (608) Starting precacheArtwork for 3 albums [14-05-14 11:51:11.1126] Slim::Music::Artwork::__ANON__ (727) precacheArtwork finished in 0.792427062988281 [14-05-14 11:51:11.1135] Slim::Music::Import::endImporter (611) Completed precacheArtwork Scan in 0 seconds. [14-05-14 11:51:11.1588] Slim::Music::Import::runScanPostProcessing (403) Starting Database optimization. [14-05-14 11:51:11.7746] Slim::Utils::SQLiteHelper::vacuum (486) Start VACUUM library.db [14-05-14 11:51:20.2276] Slim::Utils::SQLiteHelper::vacuum (511) VACUUM library.db done! [14-05-14 11:51:20.2286] Slim::Utils::SQLiteHelper::vacuum (486) Start VACUUM persist.db [14-05-14 11:51:23.0786] Slim::Utils::SQLiteHelper::vacuum (511) VACUUM persist.db done! [14-05-14 11:51:23.0796] Slim::Music::Import::endImporter (611) Completed dbOptimize Scan in 11 seconds. -------------------- kidstypike 1xSB3 - 1xBoom - 1x(Squeezebox) Radio - 2xTouch ------------------------------------------------------------------------ kidstypike's Profile: http://forums.slimdevices.com/member.php?userid=10436 View this thread: http://forums.slimdevices.com/showthread.php?t=101516 _______________________________________________ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta