4 ms·
For people who are wondering if SQLite is the right database for Wordpress, I recommend taking a look at https://www.sqlite.org/whentouse.html https://www.sqlit
by adobrawy 4y ago
For people who are wondering if SQLite is the right database for Wordpress, I recommend taking a look at https://www.sqlite.org/whentouse.html https://www.sqlite.org/whentouse.html where SQLite authors explains what sites it makes sense for.
In short: for most of Wordpress deployment, especially for long tail of hair salons, car dealerships, personal blogs and other non-tech SME sites
- ilyt 4y agoI expect it will quickly get reputation of being slow purely on how some plugins work with database. Many of them will turn relatively static site into requiring to run some inserts on every query and inserts from multiple processes is the SQLite's worst use case.
- corobo 4y agoI once was using a plugin that logged every interaction to the database.. As a post, lmao. It was using its own post type in the wp_posts table and associated post meta table. Barmy.
- CSSer 4y agoChanging away from the “wp_posts table for all things” as a convention would vastly improve WordPress performance. Talk to someone about how gross this is and they’ll start justifying it to you as “history” and then talk about how cool it is that WordPress was never meant for what it’s used for today but still works. It makes all the managed hosting feel like one big conspiracy. I can’t tell you how many times I’ve had to optimize raw queries in that stupid framework. Thank god for the rise of SSG and decoupled content management system.
- rawoke083600 4y agoMany queries are slower than few yes, but doesn't mean it'slow I think the sqLite website does like 200 queries per page view