Another new era of WordPress

Re:Another new era of WordPress by jakejake on Friday February 27, 2015 @03:07PM (#9121006)

I agree that the database is the bottleneck. I wrote a DB caching drop-in for WordPress and got pretty deep into the various queries that are running. There really aren't any nasty joins, but the problem is that the stock WordPress install with the default theme and no plugins runs nearly 30 DB queries per page. If you install once of the really slick commercial themes then WordPress will run upwards of 100 queries on every single page view.

Even a small site with a low level of traffic can bring a modest DB server to it's knees without caching of some type. It's really ridiculous but just due to the modular nature of WordPress.

[ Parent | on HN ]

Re:Another new era of WordPress by pjbrunet on Saturday February 28, 2015 @02:57AM (#9123121)

I agree. And that's just fine for 99% of the bloggers that will never reach 1 million pageviews/month. Most of those queries are unnecessary. But rather than fix the root of the problem, we put the whole database in memory. Run out of memory? No problem, move to a solid state drive! LOL.

[ Parent | on HN ]