Right. So, you want to use Trie fields for search performance, and doc values for more efficient faceting/sorting. Trie fields and doc values aren't the same.
On your field definition in your schema, you need to add docValues="true". You'll need to re-index from scratch in order to build the docValues for your field. As has been said here before, if at all possible, with a schema change like that, wipe the index and start again. Upayavira On Tue, Aug 4, 2015, at 08:25 PM, wwang525 wrote: > Hi Upayavira, > > My queries has all the features: search, sorting, grouping, faceting. As > I > was working on the project, I noticed the response time of the query got > longer and longer as I added these features. > > I was reading the solr-ref-guide-4.7, and the following is from page 66. > I > thought covert the field types to Trie* may improve the performance: > > "The standard way that Solr builds the index is with an inverted index. > This > style builds a list of terms found in all the documents in the index and > next to each term is a list of documents that the term appears in (as > well > as how many times the term appears in that document). This makes search > very > fast - since users search by terms, having a ready list of > term-to-document > values makes the query process faster. > > For other features that we now commonly associate with search, such as > sorting, faceting, and highlighting, this approach is not very efficient. > The faceting engine, for example, must look up each term that appears in > each document that will make up the result set and pull the document IDs > in > order to build the facet list. In Solr, this is maintained in memory, and > can be slow to load (depending on the number of documents, terms, etc.). > > In Lucene 4.0, a new approach was introduced. DocValue fields are now > column-oriented fields with a document-to-value mapping built at index > time. > This approach promises to relieve some of the memory requirements of the > fieldCache and make lookups for faceting, sorting, and grouping > much faster." > > Thanks > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/TrieIntField-not-working-in-Solr-4-7-tp4220744p4220821.html > Sent from the Solr - User mailing list archive at Nabble.com.