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: > > If I get that chart right, then your LMS is CPU bound. Which means it's > not waiting for I/O. > Yes, it's 100% CPU bound. There is zero I/O during the run (the DB files are already cached in RAM), which is is one of the main reasons I prefer this benchmark to rebuild library / scan for files. The I/O of reading the files introduces a lot of overhead unrelated to the DB performance, and increases variability (e.g. due to file system caching). I've posted the (quite promising) results in the ' other thread ' (https://forums.slimdevices.com/showthread.php?109460).
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