MySQL Forums
Forum List  »  Full-Text Search

Search Speed Not Increased?
Posted by: Rashmi Singh
Date: October 20, 2005 04:51AM

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.

Options: ReplyQuote

Written By
Search Speed Not Increased?
October 20, 2005 04:51AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.