SQLite Forum

Increasing insert performance of an in-memory db
Login
I'm already using a single inserter thread. I played around with multiple inserters but that didn't really improve things much (as expected).

My transaction size is 50,000. Since the bottleneck seems to be memcpy(), do you think tweaking transaction size helps much?

My journal mode is `OFF` and the database is in-memory. Looking at the documentation, I think `synchronous` matters only for writing to the disk.