4 ms·
Firstly, MySQL is actually terrible at the core task of Wordpress, which is joining tables with TEXT fields. If it finds a TEXT field it throws its hands in the
by jacques_chester 13y ago
Firstly, MySQL is actually terrible at the core task of Wordpress, which is joining tables with TEXT fields. If it finds a TEXT field it throws its hands in the air and joins on disk, taking great care to avoid any indexes you might have added to speed up those joins.
Any time the query cache isn't there to save you, you wind up stomping around on disk anyway. Fun fact: the recent comments widget that ships in mainline blows the query cache.
Secondly, file caching could still ship in mainline with a tickbox to enable it.
Thirdly, I've never seen a site that wasn't improved by file caching. However I believe you that the Wordpress guys get a lot more reports than I do.
Finally, 2005 was eight years ago.