I used `WITHOUT ROWID` option, WAL journaling mode and `synchronous = 0` and played around with `SQLITE_DEFAULT_PCACHE_INITSZ` and `SQLITE_DEFAULT_PAGE_SIZE`. I can now insert ~250,000 rows/sec. I wonder if I can push it to 1,000,000 rows/sec :).
I used `WITHOUT ROWID` option, WAL journaling mode and `synchronous = 0` and played around with `SQLITE_DEFAULT_PCACHE_INITSZ` and `SQLITE_DEFAULT_PAGE_SIZE`. I can now insert ~250,000 rows/sec. I wonder if I can push it to 1,000,000 rows/sec :).