MySQL Forums
Forum List  »  Full-Text Search

HELP :fulltext indexing problem
Posted by: Rashmi Singh
Date: October 15, 2005 12:43AM

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.....................


Options: ReplyQuote

Written By
September 08, 2005 06:09AM
September 13, 2005 12:32PM
HELP :fulltext indexing problem
October 15, 2005 12:43AM

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.