On 10/17/17, advancenOO <haveagoodtime2...@gmail.com> wrote: > In order to profile sqlite 3.9.2 and sqlite 3.16.2, I run speedtest1.c on my > mobile phone. > It is weird to find that 3.9.2 is better than 3.16.2, especially in the > following case: > “270, 10000 DELETEs, numeric BETWEEN, indexed" > 3.9.2 uses 0.7s while 3.16.2 uses 1.8s; > > My relevant compilation options are shown below: > -DSQLITE_THREADSAFE=1 > -DSQLITE_DEFAULT_AUTOVACUUM=1 > -DSQLITE_DEFAULT_PAGE_SIZE=4096 > -DSQLITE_DEFAULT_JOURNAL_SIZE_LIMIT=1048576 > > Further more, 3.16.2 performs better when I decrease the delete times from > 10000 to 1000. > So is it expected? If not, then what might be the possible reason?
It is not expected. In fact, it directly contradicts our on measurements shown here: https://www.sqlite.org/cpu.html I have no explanation for your anomalous result. Aside: This email originally went into Spam. I only discovered it, moments ago, while searching for a different message that had gone to spam. -- 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