Hello, As mentioned in another post i am trying to index a vbulletin database containing roughly 7 million posts. The very first query where I apply sorting after a full indexing, seems to take roughly <QTime>264998</QTime> ms. Subsequent searches are fast.
I figure the reason is as Chris explained here(http://www.mail-archive.com/solr-user@lucene.apache.org/msg00457.html) that "Sorting on a field requires building a FieldCache for every document -- regardless of how many documents match your query. This cache is reused for all searches thta sort on that field." However my problem is that I would like to be able to incrementally add new postings to the index, as they occur. And it appears that if i add just 1 post, and do a <commit> that solr/lucene rebuilds FieldCaches for the entire index, not just the newly added posts. Thus rendering my index unsearchable for the next roughly 264 seconds(at least for sorting queries).. Is there any solution to this problem? I would like to be able to sort, but we cant live with 264 second downtime after every commit. /Bo -- View this message in context: http://www.nabble.com/Incremental-updates-Sorting-problem-tf2071518.html#a5702953 Sent from the Solr - User forum at Nabble.com.
