Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Text Indexing and Oracle

Re: Text Indexing and Oracle

From: Remigiusz Sokolowski <rems_at_wp-sa.pl>
Date: Thu, 21 Jun 2007 08:28:34 +0200
Message-id: <467A1A92.4070009@wp-sa.pl>


Arnold, Sandra wrote:
> We are currently using Oracle Text to index our full-text documents
> and the metadata for those documents. We are finding that this may
> not be the solution because of the problems that we are having
> maintaining these indexes, mainly optimizing these indexes. We are
> looking at Lucene as a possible replacement. However, we are doing
> research to see what other products are out there that can be used for
> Text indexing. Is anyone indexing full-text documents? If so, what
> solution are you using?
>

AFAIK full text searching in MySQL is quite good solution (no such problems with index maintenance as in case of Oracle), though quite simple Another possibility is postgresql with its full text capabilities And yet another http://www.sphinxsearch.com/ (somewhat bound with MySQL)

-- 
---------------------------------------------------------------------
Remigiusz Sokolowski <rems_at_wp-sa.pl>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL v04.x,05.x; Oracle v10.x

Zastrzezenie:
Niniejsza wiadomosc stanowi jedynie wyraz prywatnych pogladow autora 
i nie jest w zadnym wypadku zwiazana ze stanowiskiem przedsiebiorstwa 
Wirtualna Polska S.A.
---------------------------------------------------------------------



WIRTUALNA  POLSKA  SA, ul. Traugutta 115c, 80-226 Gdansk; NIP: 957-07-51-216; 
Sad Rejonowy Gdansk-Polnoc KRS 0000068548, kapital zakladowy 62.880.024 zlotych (w calosci wplacony)
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 21 2007 - 01:28:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US