Originally Posted by fr3quency
Armv6 flags? So it's useless on Nexus 4/5 etc with armv7 CPUs? Can we find one which is optimised for high end devices?
No not useless, just less than optimal. Not really sure of the speedup, since I don't do benchmarks. I try to optimize it as much as possible without breaking it x_X
I was initially planning to put out both armv6 and armv7 ports at the same time, but then I realized most android utilities aren't compiled with proper 64bit file support.
So I've been trying to figure that out first. And also, most people don't use sqlite for anything earth-shattering anyway, mostly vacuum, reindex, create database from sql statements, etc.
Oooooo just saw this while searching for sqlite performance enhancements. https://sqlite.org/src4/doc/trunk/www/design.wiki
I'd also like to try to switch to musl as the standard library since alireza7991 has said it makes things smaller and faster. Not sure how feasible that will end up for me though...
It doesn't look like sqlite can parallelized at all though. See here: http://blogs.perl.org/users/timm_mur...nd-writes.html
There is a fork/variant of sqlite called paralite that uses threading, but I don't think it retains the same file format compatibility and it looks like it introduces some bugs.
Unfortunately real life stuff takes precedence so things will progress slower than I would like. But at least I know there's lots to look forward to even just for sqlite lol.