Wait how is sqlite doing a million inserts a second?
(defonce db
(d/init-db! "db/db.db"
{:pool-size 4 :pragma {:synchronous "FULL"}}))
That's writing to disk.There's only one index so there's no real write amplification. The numbers will go down as you add more data and indexes.