Re:My experience with WPEngine
by jacques_chester on Wednesday October 24, 2012 @08:56PM
(#4695841)
InnoDB helps a lot. MyISAM likes to perform joins on disk if a table has a TEXT field ... even if you're not using that field in your query.
Sorting that into a temp table, and caching that in memory would be really fast on a server with reasonable RAM and proper indexes.