Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Full Text Search
You might want to take a look at Thunderstone's Texis database at
http://www.thunderstone.com/ It was specifically designed to handle
full-text search in combination with more typical database content. I don't
know how large your documents are, but indexing time for a million documents
should be measured in minutes or hours, not days.
If your project is primarily text search you may want to use Texis by itself, or else many people run Texis alongside Oracle, letting each do what they are best at.
John
"Henry" <henry.hinze_at_berlin.de> wrote in message
news:39266aaf.0205270549.7df190e3_at_posting.google.com...
> 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 - 13:10:12 CDT