Also...here's another part of the benchmark which shows triggers aren't as evil as I thought. Trigger for this example was 2X the manual update.
F:\>d:batch 500000 1000 12 using wal mode using update trigger Sqlite Version: 3.7.5 Inserting 500000 rows using a bulk of 1000 commits per second: 71428.6 F:\>d:batch 500000 1000 20 using wal mode using manual update after insert Sqlite Version: 3.7.5 Inserting 500000 rows using a bulk of 1000 commits per second: 38461.5 Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
