Tip for optimizing large MySQL database queriesThe most important thing I've learned while working with large databases (FeedDigest's in particular) is that it's better to have 100 ridiculously quick queries than one slow one. This is really, really important. Here's a story as to why.. One of FeedDigest's common queries is that to "get a digest". In essence, it's a SQL query which grabs all the "posts" from various "feeds" and then orders the
