News for hackers. Stuff that matters.

A comment on Wp-SQLite: WordPress running on an SQLite database. Parent comment

Re:Wp-SQLite: WordPress running on an SQLite database by blenderdt on Monday May 16, 2022 @02:24PM (#31401419)
Wait, rather small as in GB!?

I don't know much about WordPress but I wouldn't expect a simple website's DB to be more than a few MB.

[ Parent | on HN ]
Re:Wp-SQLite: WordPress running on an SQLite database by andix on Monday May 16, 2022 @02:47PM (#31401702)
That's smaller than "a few GB", so no problem ;)

SQLite can get tricky, if the database files get bigger. But up to a few GB there should be no problem at all (SQLite supports up to 281 TB though)

[ Parent | on HN ]
Re:Wp-SQLite: WordPress running on an SQLite database by marpstar on Monday May 16, 2022 @02:30PM (#31401495)
They start getting a lot bigger once you start accepting and saving user input, e.g. running a WooCommerce store.
[ Parent | on HN ]
Re:Wp-SQLite: WordPress running on an SQLite database by 2000UltraDeluxe on Monday May 16, 2022 @04:38PM (#31402868)
The practical DB size limit for WordPress is around 60-70GB. After that it becomes rather sluggish.
[ Parent | on HN ]
Re:Wp-SQLite: WordPress running on an SQLite database by r2_pilot on Monday May 16, 2022 @06:51PM (#31404033)
That is terrifying that you know this. I am almost curious but would rather not know more.
[ Parent | on HN ]
Re:Wp-SQLite: WordPress running on an SQLite database by technion on Monday May 16, 2022 @10:44PM (#31405510)
It'll become unusable at a few hundred meg when it takes 180 SQL queries to render a landing page.. I wish I didn't know that either.
[ Parent | on HN ]
Re:Wp-SQLite: WordPress running on an SQLite database by 2000UltraDeluxe on Tuesday May 17, 2022 @01:29AM (#31406363)
A few hundred megs for a single page? Yes.

For an affiliate site with millions of pages you need much more to make WordPress sluggish. On the other hand, it only takes a single badly written plugin to achieve the same effect. :D

[ Parent | on HN ]