This post originated from an RSS feed registered with Java Buzz by dion. Original Post: Last-Updated: How to hit the DB as much as possible Feed Title: techno.blog(Dion) Feed URL: http://feeds.feedburner.com/dion Feed Description: blogging about life the universe and everything tech Latest Java Buzz Posts Latest Java Buzz Posts by dion Latest Posts From techno.blog(Dion)

While debugging an application, MySQL was crashing and the log was sent over to me. There were hundreds of the same SELECT query (that wasn't tuned too).

After hunting it down, this query was run for every RSS query, calculating the last time the event was updated.

We changed this value to be cached (in-memory speed for lookup on each request) and the issue died.