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.
Database Optimization for Rails Apps
blog.nbwd.co.uk