I have a page where i go through all categories, and show the latest 3 games for each one. Right now i include those games when i fetch the categories in the controller:
@categories = Category.find :all, :include => [:online_games]
Is there a way to limit those games here to the amount that i want? It seems a bit inefficient to get all games per category here, and limit those in the view.
Peter wrote:
I have a page where i go through all categories, and show the latest 3 games for each one. Right now i include those games when i fetch the categories in the controller:
@categories = Category.find :all, :include => [:online_games]
Is there a way to limit those games here to the amount that i want? It seems a bit inefficient to get all games per category here, and limit those in the view.
Why would not :limit => 3 work?
because that would limit the categories to 3, not the games.
Peter wrote:
because that would limit the categories to 3, not the games.
On Mar 17, 4:08 pm, James Byrne <rails-mailing-l...@andreas-s.net>
more than what you are asking, you can make it the default :limit option when eager loading associations.
i searched for 'eager loading associations ruby rails' in google: http://api.rubyonrails.com/classes/ActiveRecord/Associations/ClassMethods.html in this page, search for 'limit'.
you can add a :limit => n number to the declaration in the model (has_many .. :limit => ) or whatever as the default limitation for the association you want to query.
hope it helps out 
shai