Static or DB Drive? Convince me
I get myself into these arguments, well discussions that always turn into everyone believing their right without backing it up with anything tangible.
The question posed on my Discord Channel was:
"Which 5,000 post blog will return the best overall performance, a blog built using MySQL with something like WordPress or one built using a static site building tool, Textpattern, Grav, Hugo and so on?"
Interestingly there were a lot of comments supporting both, the main argument for a large database-driven site was mostly one thing:
Better indexing therefore faster searching and better experience for end-users.
On the other hand, the static site supporters said:
With NVMe, larger sites perform effortlessly even with a very high object count
Lower page load overheads make up for potentially less efficient out of the box indexing/caching
Many large WP site owners convert their pages to static content via a plugin, what does that tell you?
Interested in the views from folks here who may have experience with both. I have sites that use both, whilst the static sites way outperform the database-driven ones, they are too small to really compare.