Store fields in database or in Lucene index file

Question

Hi All,

My domain object is pretty simple, only have 20 properties(columns, or fields, whatever you call it) and does not have complex relationship. I need to index 5 of them for full text search and 3 need for sort. There might be 100,000 records.

To keep my application simple, I'm thinking store all fields in Lucene index file to avoid introducing database. Will there be performance problem for this implementation?

Thanks.

Answer 1

Depending on how you access stored fields, they may all be loaded into memory (basically, if you use a FieldCache everything will be cached into memory after the first use). And if you have a gig of storage which is taking up memory, that's a gig less to use for your actual index.

Depending on how much memory you have, this may be a performance enhancement, or a performance detriment.