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. 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 Dennis Cote
