mherger wrote: > Running this kind of stuff in a loop would likely only hit SQLite's > buffer - which is not representative either. > Not sure about that. If I were to speculate: SQLite doesn't seem to do any real query caching, and the buffer seems very limited, leading to a weird spiking performance profile: 25622 (bar chart = seconds one execution of the benchmark takes) No I/O, Database Memory Config: high (LMS consumes about 400MB RAM), nothing else running on the RPi3 > > In general I've had little reason for complaints > with my setup in day-to-day use. But I know that eg. some of Erland's > plugins are extremely heavy on database stuff. If you're running one of > > those, that might be interesting, too. > I've added some trackstat:
Code: -------------------- BCMDS='{"id":1,"method":"slim.request","params":["-", ["playlists", 0, 999]]} {"id":1,"method":"slim.request","params":["-", ["titles", 0, 99,"tags:acCdefgGiJklnpPDqrROstTuwy"]]} {"id":1,"method":"slim.request","params":["-", ["albums", 0, 999,"genre_id:771"]]} {"id":1,"method":"slim.request","params":["-", ["artists", 0, 999,"genre_id:771"]]} {"id":1,"method":"slim.request","params":["aa:bb:cc:dd:ee:ff", ["trackstat", "statisticsjive", "statistics:topratedgenres", "_start:1","_itemsPerResponse:999"]]} {"id":1,"method":"slim.request","params":["aa:bb:cc:dd:ee:ff", ["trackstat", "statisticsjive", "statistics:topratedartists", "_start:1","_itemsPerResponse:999"]]} {"id":1,"method":"slim.request","params":["aa:bb:cc:dd:ee:ff", ["trackstat", "statisticsjive", "statistics:notcompletelyratedalbums", "_start:1","_itemsPerResponse:999"]]} {"id":1,"method":"slim.request","params":["aa:bb:cc:dd:ee:ff", ["trackstat", "statisticsjive", "statistics:leastplayedalbums", "_start:1","_itemsPerResponse:999"]]} {"id":1,"method":"slim.request","params":["aa:bb:cc:dd:ee:ff", ["trackstat", "statisticsjive", "statistics:mostplayednotrecent", "_start:1","_itemsPerResponse:999"]]} {"id":1,"method":"slim.request","params":["aa:bb:cc:dd:ee:ff", ["trackstat", "statisticsjive", "statistics:mostplayednotrecentartists", "_start:1","_itemsPerResponse:999"]]} {"id":1,"method":"slim.request","params":["aa:bb:cc:dd:ee:ff", ["trackstat", "statisticsjive", "statistics:partlyplayedartists", "_start:1","_itemsPerResponse:999"]]} {"id":1,"method":"slim.request","params":["-", ["search", 0, 999,"term:Front"]]} {"id":1,"method":"slim.request","params":["-", ["playlists", "tracks", 0, 999,"playlist_id:475485", "tags:acCdefgGiJklnpPDqrROstTuwy"]]}' -------------------- Results are compareable (one benchmark run takes 42s/26s) , only the spike occurs every third run. Increasing Database Memory Config to max shaves off ~1sec, but doesn't do anything else (there is no significant increase of memory consumption, either) I'll repeat these with a newly-built library.db and with the the old SQLite version. +-------------------------------------------------------------------+ |Filename: atop.png | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=25622| +-------------------------------------------------------------------+ SW: 'Web UI for LMS' (http://forums.slimdevices.com/showthread.php?98186-Announce-Alternative-Web-Interface-(beta)) | 'Playlist Editor / Generator' (http://forums.slimdevices.com/showthread.php?108199-Announce-LMS-Playlist-Editor) | 'Music Classification' (http://forums.slimdevices.com/showthread.php?108278-Announce-Essentia-Integration-music-classification-(moods-genres-)) | 'Similar Music' (http://forums.slimdevices.com/showthread.php?108495-Announce-LMSmusly-play-similar-music) | 'LMSlib2go' (https://www.nexus0.net/pub/sw/lmslib2go/) HowTos: 'build a self-contained LMS' (http://forums.slimdevices.com/showthread.php?99648-Howto-build-a-self-contained-LMS) | 'Ogg Opus' (http://forums.slimdevices.com/showthread.php?107011-Howto-play-Ogg-Opus-files) | 'Bluetooth/ALSA' (http://forums.slimdevices.com/showthread.php?107230-Howto-Bluetooth-streaming-to-from-LMS-(ALSA-only-no-PulseAudio)) ------------------------------------------------------------------------ Roland0's Profile: http://forums.slimdevices.com/member.php?userid=56808 View this thread: http://forums.slimdevices.com/showthread.php?t=109325 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss