+1 for Inguz.
As I said before: this is not going to happen.
A current version of SQLite. There have been quite a few releases that improve performance over the last few years - https://sqlite.org/changes.html .
Any volunteers to test this change on the 29 platforms we support? Ok, we can say we only update the top 5 platforms. Which are? And who is going to test whatever change we need to apply to the code to make it compatible doesn't break compatibility with the older version?
What looks like a simple enough change would be a huge amount of work, and some risk to break things, too.
I'd be willing to look into this if somebody could update it for Windows and whatever recent Linux flavour and give it some thorough testing. But as long as I'd have to do it all by myself, it's simply too much.
Another option in Settings / Performance to use more memory for computers with > 3GB RAM - as an attempt to get some lookups e.g. new music, to perform better on Windows based servers.
Optimization cannot always be done by throwing RAM at them. Some of the biggest improvements in 7.8 didn't require much more memory, but some work to understand where the bottlenecks were, and how to tackle them. Further improve performance on Windows specifically will require some thorough analysis of the problem first.
-- Michael _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
