Hi All, I have a model called colleges, that contains college name, speciality, location, articles on colleges, etc. So, I want to create a catalog for users to browse. I want a listing based on location, speciality, name, etc. And want to display articles related to these fields. If I do a SELECT DISTINCT, everytime I display the page, this will take query all the fields and it takes time. In the sense, i am doing @colleges = College.find(:all, :select=>"DISTINCT location") Is there a better way of doing this? Should I have a seperate table for the statistics? Please help me with this. Thnx, --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---