I'm using sqlite3 for a logging function. If I don't need any concurrency (there's only one writer all the time), but I need fast inserts what journal mode should I choose?
1 Answers
WAL mode needs less synchronization, so writes are faster, except when the database decides to do a checkpoint.
Related