Dennis Cote wrote:
Erik Jensen wrote:
very interesting. Do you have the chance to run the same test with
version 3.2.1? Like i wrote in an earlier message, i noticed a similar
performance drop when i upgraded my application from sqlite 3.2.1 to
3.3.5.
Eric,
I reran these test using 3.2.1 dll downloaded from the sqlite website.
It is very similar to the results from 3.3.5. It is slightly slower for
all except the memory insert without transaction case. So it doesn't
look like the big change happened after 3.2.1.
On a whim, I tested 3.0.8 and 3.3.4:
SQLite DB TX records inserts/sec
=======================================================
3.3.5 :memory: no 1M 2778
3.3.5 :memory: yes 1M 22727
3.3.5 file no 1K 10
3.3.5 file yes 1M 24390
3.2.1 :memory: no 1M 2857
3.2.1 :memory: yes 1M 21739
3.2.1 file no 1K 9
3.2.1 file yes 1M 22727
2.8.17 :memory: no 1M 62500
2.8.17 :memory: yes 1M 58824
2.8.17 file no 1K 13
2.8.17 file yes 1M 23256
3.3.4 :memory: yes 1M 25866
3.3.4 file yes 1M 28587
3.0.8 :memory: yes 1M 20573
3.0.8 file yes 1M 22903
It seems there were some significant performance improvements in between
the two versions!
Arun
