My document store has 750K users who wrote 100M reports. The size of a report ranges from 1k to 2M. I have read in several places that actual values (text) can be stored in DB, while lucene only manages index with Field.Store.NO
I wonder any differences in performance (search and match retrieval) between Field.Store.YES and NO values. For example, if actual report contents are stored in a DB (Field.Store.NO), given a search that matches 500 reports, one has to send either 500 SELECT queries to DB, or one long SELECT with IN clause in WHERE condition. Or something in between. Is this faster than retrieving them from index created with Field.Store.YES. Does NOT storing actual values in index make the search faster? Any pointer would be appreciated. Thanks -- View this message in context: http://www.nabble.com/Performance%3A-Field.Store.YES-vs.-Field.Store.NO-%2B-DB-tp23987086p23987086.html Sent from the Lucene - General mailing list archive at Nabble.com.
