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
11377
December 18, 2004 08:18AM
6086
December 18, 2004 11:18AM
4511
December 21, 2004 08:40AM
4535
December 21, 2004 11:27AM
4216
December 22, 2004 02:02AM
5843
December 22, 2004 07:54AM
Re: FULLTEXT Search performance
4068
December 31, 2004 08:09PM
3958
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.