# Wanna make a catalog list

**URL:** <https://www.ruby-forum.com/t/wanna-make-a-catalog-list/107511>\
**Category:** Rails\
**Created:** [June 22, 2007, 12:33pm UTC](https://www.ruby-forum.com/t/wanna-make-a-catalog-list/107511 "2007-06-22T12:33:07Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![vanquisher](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/f9ae1b/32.png) [@vanquisher](https://www.ruby-forum.com/u/vanquisher)\
**Post date:** [June 22, 2007, 12:33pm UTC](https://www.ruby-forum.com/t/wanna-make-a-catalog-list/107511/1 "2007-06-22T12:33:07Z")

</div>

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,