search for: imageprofile

...ds. 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 joins and queries down the stack. I built a query for a subset of the reviews belonging to @submission: @current_reviews = Review.find(:all, :conditions => cond) The query takes 20 milliseconds. [cond is along the lines of finding max(id) where sub...