SQLite Forum

Increasing insert performance of an in-memory db
1) It's not a `WITHOUT ROWID` table. Does it have an impact on insert performance?
2) The strings are between 0 and 10000 bytes long. On average they are around 70 bytes long. I use `SQLITE_STATIC` while binding them to my prepared statement.