3 ms·
Back in the day, WordPress always ran on Apache with mod_php, correct? Wouldn't that be unsafe to use sqlite, since every request ran in a separate thread?
by zdragnar 3y ago
Back in the day, WordPress always ran on Apache with mod_php, correct? Wouldn't that be unsafe to use sqlite, since every request ran in a separate thread?
- graemep 3y agoSeparate 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.