News for hackers. Stuff that matters.
Re:My experience with WPEngine by jacques_chester on Wednesday October 24, 2012 @12:19PM (#4693593)
From memory, the relevant fields are already indexed.
Re:My experience with WPEngine by aoe on Wednesday October 24, 2012 @02:02PM (#4694153)
I'm guessing the recent comments widget is just doing an ORDER BY date DESC LIMIT 10 or something? With an index on date, I don't see how this could be slow.

How long does the query take?

How many rows do you have?

Re:My experience with WPEngine by ashray on Wednesday October 24, 2012 @02:18PM (#4694254)
Appears that he has 188590 rows. It definitely sounds like a configuration issue. Maybe the mysql table cache might be bogged down or the query cache is full or malfunctioning. Could be a lot of things.

Sorting that into a temp table, and caching that in memory would be really fast on a server with reasonable RAM and proper indexes.

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.