I've been running LMS with 'updated modules / libraries ' (http://forums.slimdevices.com/showthread.php?107040-Howto-update-perl-modules-bundled-with-LMS) (DBD::SQLite 1.54 (sqlite 3.13.0)) since 03/2017 on a RPi3 without any issues.
Great! Any improvements you've experienced?
I can confirm that fulltext indexing is painfully slow, however, since I haven't tried it with any other version of SQLite, I have no comparison.
That's an odd one. In my previous tests this was constant. Every test I did was a massive slow down in FTS. But I always did delete the library.db to start from scratch for every test. Now I repeated the test for the same collection, without deleting that file, and performance was as before (plus speed up in other aspects). As if re-using a file was much faster than growing it from zero.
I'm now running my own system at home on an oldish Intel Atom CPU with the latest DBD::SQLite. In this "real life" scenario with about 20k tracks, several plugins which use the database in some aspect extensively (Music And Artist!), it's about 20% faster over all, with FTS being pretty much the same as before.
I'll try to update my pCP based system, too, to get another datapoint. And I'll run a bunch more tests with my testing environment and the 100k library, using the tweaked DBD::SQLite update (stock vs. some stuff disabled, plus ICU support added). And then I'd have to figure out how to compile this for Windows...
-- Michael _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
