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
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss
