3 ms·
Writes and changes to the database itself are locked to a single process at a time, per your link. If the load is very read heavy the write locks aren't an iss
by zdragnar 3y ago
Writes and changes to the database itself are locked to a single process at a time, per your link.
If the load is very read heavy the write locks aren't an issue, but if you're tracking page views, comments or any other write-heavy feature, it'll be harder to get good performance.
- simonw 3y agoBenchmark it with WAL mode turned on. You may be pleasantly surprised.