Hello Dennis, DC> My results are summarized below.
DC> SQLite DB TX records inserts/sec DC> ======================================================= DC> 3.3.5 :memory: no 1M 2778 DC> 3.3.5 :memory: yes 1M 22727 DC> 3.3.5 file no 1K 10 DC> 3.3.5 file yes 1M 24390 DC> 2.8.17 :memory: no 1M 62500 DC> 2.8.17 :memory: yes 1M 58824 DC> 2.8.17 file no 1K 13 DC> 2.8.17 file yes 1M 23256 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. If the performance of 3.2.1 is still ok, then the slowness must have happened anywhere between 3.2.1 and 3.3.5. Regards, Eric
