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
