Re: Full Text Search

From: Thomas Hesse <thomas.hesse_at_team.xtra.co.nz>
Date: Tue, 28 May 2002 10:49:34 +1200
Message-ID: <3CF2B7FE.23150180@team.xtra.co.nz>

Hi Henry,

maybe your configuration is not the best e.g.

- memory clause with your create index statement 
- disable INSO filter, because you have only text documents
- i/o contention ?

If you provide more information, maybe I can help to improve the index creation process (Hardware, OS, SGA, size of documents, charset, index preferences)

Cheers
Thomas

Henry wrote:
>
> Hi,
>
> we have to program a full text search over 1 Million Documents, stored
> as CLOB data. To index the tables with Intermedia it takes over
> 12days!!! That seems very long. Does anybody knows another good search
> tool for oracle or why does it take so long?
> We use Oracle 8.1.7
>
> Thanx!
>
> Henry
Received on Mon May 27 2002 - 17:49:34 CDT