I am working on an application that currently hits a database containing
millions of very large documents. I use Oracle Text Search at the moment, and
things work fine. However, there is a request for faceting capability, and Solr
seems like a technology I should look at. Suffice to say I am new
ot;? I've
indexed, as a single document, a 26 volume encyclopedia of civil war
records..
Although as much as I like the technology, if I could get away without using
two technologies, I would. Are you completely sure you can't get what you
want with clever Oracle querying?
Best
Eric
Smiley
Author: http://www.packtpub.com/solr-1-4-enterprise-search-server/
On Mar 16, 2010, at 4:13 PM, Neil Chaudhuri wrote:
> Certainly I could use some basic SQL count(*) queries to achieve faceted
> results, but I am not sure of the flexibility, extensibility, or scalability
> of that a
Since my original thread was straying to a new topic, I thought it made sense
to create a new thread of discussion.
I am using the DataImportHandler to index 3 fields in a table: an id, a date,
and the text of a document. This is an Oracle database, and the document is an
XML document stored as
though.
Shawn
On 3/16/2010 4:59 PM, Neil Chaudhuri wrote:
> Since my original thread was straying to a new topic, I thought it made sense
> to create a new thread of discussion.
>
> I am using the DataImportHandler to index 3 fields in a table: an id, a date,
> and the text of
s_packages/ddp_dbms_lob.htm
I also was trying to find a way to convert from xmltype directly to a
string in a query, but that quickly got way over my level of
understanding. I saw hints that it is possible, though.
Shawn
On 3/16/2010 4:59 PM, Neil Chaudhuri wrote:
> Since my original thread was
I am using the DataImportHandler to index 3 fields in a table: an id, a date,
and the text of a document. This is an Oracle database, and the document is an
XML document stored as Oracle's xmltype data type. Since this is nothing more
than a fancy CLOB, I am using the ClobTransformer to extract
Incidentally, I tried adding this:
But this didn't seem to change anything.
Any insight is appreciated.
Thanks.
From: Neil Chaudhuri
Sent: Wednesday, March 17, 2010 3:24 PM
To: solr-user@lucene.apache.org
Subject: XPath Processing Applied to Cl
I am using the DataImportHandler to index literally millions of documents in an
Oracle database. Not surprisingly, I got the following after a few hours:
java.sql.SQLException: ORA-04030: out of process memory when trying to allocate
4032 bytes (kolaGetRfcHeap,kghsseg: kolaslCreateCtx)
Has anyo
