Search Speed Not Increased?
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
Subject
Views
Written By
Posted
Search Speed Not Increased?
3521
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.