[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]

Reply via email to