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 > 3.9.2+1024 > 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 example. 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 d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users