MySQL Forums
Forum List  »  Full-Text Search

full_text_search indexing problem
Posted by: Rashmi Singh
Date: October 15, 2005 12:57AM

Hello ,

I am working on my companys site which is a job portal. In this we have a text serach option which is used to find resumes based on a keyword. The resume is stored in a field in the database. Now as the databse records have increased (about 2 lakhs) the text serach has gone slow. so i plan to shift the query based on 'like ' operator to FULLTEXT . Now for that i would have to create the FULLTEXT index. But the problem with this is ...... if i'll start indexing such a huge database records , it will take hell lot of time ........... So is there a way to minimize this time or is there any other way to increase the speed of my serach.
PLZ HELP.....................

R

Options: ReplyQuote


Subject
Views
Written By
Posted
full_text_search indexing problem
2914
October 15, 2005 12:57AM


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.