search for: submission_id

I made what I think is a small change yet the change in my app was disastrous - cpu spun, memory went out of control, and mongrel crashed within seconds. I have a controller which takes a param for submission_id . Submissions have 1 or more reviews, and reviews each have one image. There may be more than one image per submission. The view (and partial) code does some very intense things, like @ submission.reviews.each | review | review.image.imageprofile.releases.empty? , etc. No doubt causes huge join...

Hey everyone, I am working on an application that allows users to submit articles, and also comment on those articles. Pretty much exactly like Digg. Everything works fine except that when there are a lot of comments there are a lot of database queries to both fetch the comments and the users who posted those comments. I have used eager loading in other parts of my application to reduce the