SQLite Forum

WAL mode speed vs normal comparison
Login
An *heavy-insert* scenario is not faster with WAL, in my experience.  
That was a while ago, but that *in most scenarios* comment from the doc  
might be misleading a bit. My $0.02.

While many concurrent reads with occasional writes will be a lot faster,  
**in aggregate**, because of much less contention on locks.