[EMAIL PROTECTED] a écrit :
The need is:
I have millions of entries in database, each entry is in such format (more or
less)
ID Name Description start (number) stop(number)
Currently my application uses the database to do search, queries are in the
following format:
Select * from table where Name like "%mymymy%"
Select * from table where start >5 and stop <50000
I would like very much to use Lucene for such search, for the reason:
1. database performance is not ideal;
2. data is growing to be too big, I want to move to file system,
3. Currently everything is on server, user access through a web application. I
want to provide rich client tool, in which case I would rather not to bother
with database installations on client machine. Database is my last option;
4. Lucene sounds very cool, I want to use a different technology than database,
which we are very familiar with already.
I read the book, played with the demo. My question is:
As you see, I'm not indexing or querying out documents, I'm interested in one
row of data. If I want to use Lucene, how should I do it? Do I have to store my
data as documents? Since I have millions and millions of rows in database, if I
store each row as a document, it'd be millions of documents.
Each line is a Document, and row are Field. Field like Description will
be stored (and even compress).
M.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]