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
11546
December 18, 2004 08:18AM
6221
December 18, 2004 11:18AM
4608
December 21, 2004 08:40AM
4633
December 21, 2004 11:27AM
4381
December 22, 2004 02:02AM
6069
December 22, 2004 07:54AM
Re: FULLTEXT Search performance
4117
December 31, 2004 08:09PM
3999
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.