FULLTEXT search problem

[R_Singh]

Hello frnds,

I am working on my company's site which is a job portal, there we have an option for searching the resume on the basis of the keywords (like java,j2ee,team lead etc.......)serached in the resume text
.The resumes are stored as a field in the database.The database we are using is MySQL 4.1.Our databse has >3 lakh records.As the databse has grown in size this serach is performing v poorly . So we desided to use FULLTEXT serach of mysql , previously we were using like operator.But still the speed has not increased much. Why?

Can anyone help me with this.
Thanks
bye

[Najjar]

Try to index the table(s)
and not use arrays in you search page
I had some problems like this and the array was the problem.

[chigs20]

1. Try optimizing the tables. Use the myisamchk utility.

2. Using some app (SSH, MySQL Control Center, ...) put the words 'EXPLAIN' in front of the query and it will, just that, explain what order the query is being executed, with what indexes and how many records it is retreiving per table.
http://dev.mysql.com/doc/refman/4.1/en/explain.html