Is there any reason why LMS is using such an old SQLite version, 3.7.7.1 which dates back to 2011.
There are many potential reasons. Call it laziness, or "never touch a running system", or lack of priorities, premature optimization, lack of time...
Updating the library for all platforms is virtually impossible. Dealing with the potential issues of running different versions on different platforms might lead to some unwanted decisions (eg. rollback, drop support for some platforms etc.) and certainly would consume considerable amounts of time. Which probably would better be spent elsewhere.
Maybe there just isn't any compelling reason to update.
Looking through the SQLite release log there seem to be pretty impressive performance gains made over the years so just wondering why this hasn't been rolled into LMS. (DBD-SQLite-1.58 released March 2018)
Did you carefully read where those improvements would apply? Does it apply to LMS? Did you confirm it's any faster at all? And where do you see the database as the bottleneck, btw?
I'd be happy to see a thorough comparison of current LMS and LMS on latest SQLite, scanning libraries of various sizes (5k, 30k, 100k) on various platforms (Pi, Mac, Windows, desktop Linux). Or at least one of them showing that "impressive performance gain". What would you measure? Scanning time? Browsing performance? Time to playback?
PS Can we have the old forum software back.. thanks :p
Can it get any older?... it's vbulletin 4, announced in 2009. Its successor v5 was announced in 2012. We never updated beyond security updates.
-- Michael _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
