I am trying to see the insert performance of SQLite3 for a large number of inserts, I read about WAL mode, and how it is better at concurrency but I cannot follow on the concurrency part or see a speed improvement.

I’m using sqlite3 for the first time and don’t know what I’m doing. This is from a wiktionary dump.