MySQL Forums
Forum List  »  Full-Text Search

Re: FULLTEXT Search performance
Posted by: Peter Zaitsev
Date: December 31, 2004 08:09PM

How large is your data file ? Also what is the system load during the query - is it CPU bound or Disk bound ?

One of the things - you could try using MATCH IN BOOLEAN MODE which is often much faster than "natural language search".

Options: ReplyQuote


Subject
Views
Written By
Posted
11450
December 18, 2004 08:18AM
6155
December 18, 2004 11:18AM
4574
December 21, 2004 08:40AM
4597
December 21, 2004 11:27AM
4346
December 22, 2004 02:02AM
6035
December 22, 2004 07:54AM
Re: FULLTEXT Search performance
4086
December 31, 2004 08:09PM
3972
April 15, 2005 08:59AM


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.