On 2/1/18, Nick <haveagoodtime2...@gmail.com> wrote:
> I update sqlite in my Android mobile phone from 3.9.2 to 3.16.2.
> There are many test cases in speedtest1.c and case 270 is a DELETE case
> which is the most time-consuming one.
> There is a result. (different version + different page_size)
> 3.16.2+4096 3.16.2+1024 3.9.2+4096
> Case 270: 5.695s 5.908s 2.307s
We get very different results when comparing the performance of 3.9.2
to 3.16.2. See the graph at https://www.sqlite.org/cpu.html for
Since in your case, the 3.9.2 was compiled by Google and you compiled
3.16.2 yourself, I suggest that there might be some difference in your
compiler or compiler settings.
D. Richard Hipp
sqlite-users mailing list