Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Text Indexing and Oracle
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-lReceived on Thu Jun 21 2007 - 01:28:34 CDT
![]() |
![]() |