Re: FULLTEXT Search performance
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".
Subject
Views
Written By
Posted
11747
December 18, 2004 08:18AM
6330
December 18, 2004 11:18AM
4680
December 21, 2004 08:40AM
4715
December 21, 2004 11:27AM
4446
December 22, 2004 02:02AM
6154
December 22, 2004 07:54AM
Re: FULLTEXT Search performance
4193
December 31, 2004 08:09PM
4086
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.