Folks, any thoughts? On May 24, 7:15 pm, badnaam <[email protected]> wrote: > Thanks! > > Let me clarify. > > On my home page, I would like to show the following > > top 10 clubs in your area > most popular comments in your area > popular events in your area.. > . > . > and so on. > > This view will essentially show 10-15 records from 7-8 models. Which > is a lot of queries and of course, its the home page, which I wanna > make sure loads fast. > > What's the best way to optimize it? > > Should I have another model called popular with colums names such as > popular_events, popular_clubs, etc and populate/depopulate that with a > background job? or is there a better way? > > Thanks > > On May 24, 6:06 pm, Ritchie <[email protected]> wrote: > > > > > Check out the :counter_cache option of belongs_to. If you order by > > that and limit to 10, you'll probably have what you're after. > > > /Ritchie > > > On May 25, 12:42 am, badnaam <[email protected]> wrote: > > > > What's the best way to handle views that show the top 10/most popular/ > > > Recently updated/most commented type listing? > > > > Should I have a separate model that is populated with records from > > > other models by a background job or should I need to use some sort of > > > caching? Perhaps both? > > > > Thanks! > > > > -- > > > You received this message because you are subscribed to the Google Groups > > > "Ruby on Rails: Talk" group. > > > To post to this group, send email to [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]. > > > For more options, visit this group > > > athttp://groups.google.com/group/rubyonrails-talk?hl=en. > > > -- > > You received this message because you are subscribed to the Google Groups > > "Ruby on Rails: Talk" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group > > athttp://groups.google.com/group/rubyonrails-talk?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group > athttp://groups.google.com/group/rubyonrails-talk?hl=en.
-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
