SQLite Forum

WAL mode speed vs normal comparison
Login
There are a bunch of multi-thread, multi-processing, multi-access considerations.  If you have a just one thread of one process of one program accessing the database, and a ton of memory and filespace free, WAL is significantly faster.  In other scenarios which is faster depends on many things, not only what commands (read or write) you're doing simultaneously, but also things like which operating system and file system you're using.

So you can describe a bit more what you're doing.  But you can get precise answers by writing your software and testing it in WAL and not-WAL journal modes.  After all, it's simple to switch from one to another.