On 2/1/18, Nick <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

