Here are the results from the benchmark posted in 'this thread' (https://forums.slimdevices.com/showthread.php?109325-Why-is-LMS-using-such-an-old-SQLite-version): 25638 The first graph is without the trackstat queries, the second with them. Each pair of bars (red for old SQLite / blue for new SQLite) represents a single run of the benchmark. At least on this system (RPi3), the speedup is significant and noticeable in interactive use of DB-bound functionality (e.g. show all tracks by an artist, TrackStats top rated genres etc.)
+-------------------------------------------------------------------+ |Filename: lms-dbd.png | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=25638| +-------------------------------------------------------------------+ 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=109460 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
