Comment by nikisweeting

Sure the actual write might only take 1s but the transaction might lock for 10ms.

Does SQLite support overlapping write transactions with locks on different rows?

Also do you know if WAL2 mode changes anything? https://www.sqlite.org/cgi/src/timeline?r=wal2