Database Optimization for Rails Apps (blog.nbwd.co.uk)

The reporting application I'm working on does a date-range select against a table with ten million rows. It took over two minutes to execute. I cut it down to around two seconds without significantly changing the application. Here's how.