3 ms·
Separate prcoesses because php was not thread safe back then. SQLite can handle multiple processes: https://www.sqlite.org/faq.html#q5 https://www.sqlite.org/f
by graemep 3y ago
Separate prcoesses because php was not thread safe back then.
SQLite can handle multiple processes: https://www.sqlite.org/faq.html#q5 https://www.sqlite.org/faq.html#q5
I am not sure it could back then
- zdragnar 3y agoWrites 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.