Sqlite Wal Mode : How Much Time Should I Expect To Be Locked In Wal Mode?

I plan to use Sqlite with WAL mode (on a web server). As I understand, the reads are never blocked with this mode, even when write occurs in the same time. There is still only one

Solution 1:

It is very quick. I have a web based API (PHP+SQLite) that processes 2 to 5 million (read/write) transactions per month. With PRAGMA journal_mode = WAL there have been no issues. This is only observational data I know, but thought it might be helpful.