How to index a TEXT field to increase search performance?

[sudhakaranr]

Hi all....

I am using table, which has 5 million rows. In this, i have a column called "comp_name" . this is defined as TEXT.

If i want to search a particular pattern in the text field, it is taking enormous time.

so, i want my search faster....

What are the possibilities to make it faster?

Your help is highly appreciable.... ..

Thanks

[r035198x]

You are on the right path. Are you using MyISAM for this table?
Here is a good starting point.

[Atli]

I've cleaned up the title of this thread and made it a little clearer.
Please refrain from flooding your titles with question and exclamation marks!

[sudhakaranr]

Hey,

Thanks. But, I used this Full text search in my table. but, i couldn't search less than 3 characters as my input. so What is the solution for this?


sudhakar

[Atli]

Try reading the link he already posted.
More specifically, the 'Fine-Tuning MySQL Full-Text Search' part.