Hello, the requirement which I have is that on solr side we have indexed data of multiple customers and each customer we have at least a million documents. After executing search end user want to sort on some fields on datagrid lets say subject, title, date etc.
Now as the sorting on text fields is costlier what optimisation I can do for that, I am thinking of following options 1)Create a custom cache and for each customer hold the list of documents in sorted order of each of the field on which we want to sort . So that when request for sorting comes from the user I can return a list from cache 2)Use filter query cache , where customer id criteria is added so that each time I get the docs from filter cache Please can anybody tell me whether this is the good approach or there is some better way of doing this? I am using solr 3.6. Thanks in advance. -- View this message in context: http://lucene.472066.n3.nabble.com/How-can-I-optimize-Sorting-on-multiple-text-fields-tp3990874.html Sent from the Solr - User mailing list archive at Nabble.com.
