SQLite Forum

sqlite write performance is slower than the filesystem
Login
SQLite also does extra work on the write-path compared to your text implementation, to ensure durability. ie. it calls fsync() to ensure the data is actually on disk.

You can try adding this for benchmarking purposes: `PRAGMA synchronous=OFF`

But note that this is not considered a safe option in production - if a machine loses power mid-transaction then you'll end up with a corrupt database.