query performance boost

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?

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/dynamic-format.html