# query performance boost

**URL:** <https://discuss.rubyonrails.org/t/query-performance-boost/38380>\
**Category:** rubyonrails-talk\
**Created:** [January 16, 2009, 8:47am UTC](https://discuss.rubyonrails.org/t/query-performance-boost/38380 "2009-01-16T08:47:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![11175](https://avatars.discourse-cdn.com/v4/letter/1/8edcca/32.png) [@11175](https://discuss.rubyonrails.org/u/11175)\
**Post date:** [January 16, 2009, 8:47am UTC](https://discuss.rubyonrails.org/t/query-performance-boost/38380/1 "2009-01-16T08:47:02Z")

</div>

Ukrit Himakoon wrote:

> I've a table with structure like this:
> 
> id: int field1: varchar(255) field2: int(11) field3: text field4: text field5: varchar(255) field6: varchar(255)
> 
> assume that this table contains massive contents on field 3 and 4 So any way that I will be able to access this table quicker than my current query?
> 
> And this is the way I'm access this table:
> 
> Table.find(:all, :include=\> "relate\_table")
> 
> please give me some hint (and I need all fields to display on page)

would anyone mind giving some idea?

---

<div class="post-metadata">

**Author:** ![Shiv\_N\_Gautam](https://avatars.discourse-cdn.com/v4/letter/s/f1d935/32.png) [@Shiv\_N\_Gautam](https://discuss.rubyonrails.org/u/Shiv_N_Gautam)\
**Post date:** [January 16, 2009, 9:07am UTC](https://discuss.rubyonrails.org/t/query-performance-boost/38380/2 "2009-01-16T09:07:13Z")

</div>

Assuming you’re using MySQL these might help you.

[http://dev.mysql.com/doc/refman/5.1/en/static-format.html](http://dev.mysql.com/doc/refman/5.1/en/static-format.html)[http://dev.mysql.com/doc/refman/5.1/en/dynamic-format.html](http://dev.mysql.com/doc/refman/5.1/en/dynamic-format.html)