Re: Text Indexing and Oracle
- From: Remigiusz Sokolowski <rems@xxxxxxxx>
- To: ArnoldS@xxxxxxxx
- Date: Thu, 21 Jun 2007 08:28:34 +0200
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@xxxxxxxx>
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)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
