Actually using facet.method=enum made a HUGE difference even in my case where I have many unique values. I am happy with the query response time now.
Is there a way in SOLR to count the unique values for a field? If not, I could run the reindexing and count the unique values while I add them to give you a more accurate count of how many I have (there is a good chance that I have more than 500K). Thanks, Maria On Fri, Apr 21, 2017 at 1:16 AM, alessandro.benedetti <a.benede...@sease.io> wrote: > Hi Maria, > If you have 100-500.000 unique values for the field you are interested in, > and the cardinality of your search results is actually quite small in > comparison, I am not that sure term enum will help you that much ... > > To simplify, with the term enum approach, you iterate over each unique > value, if it matches the prefix and then you count the intersection of the > result set with the posting list for that term. > In your case, your result set is likely to be much smaller than the number > of unique values. > I would assume you are using the fc approach, which in my opinion was not a > bad idea. > Let's start from the algorithm you are using and the schema config for your > field, > > Cheers > > > > ----- > --------------- > Alessandro Benedetti > Search Consultant, R&D Software Engineer, Director > Sease Ltd. - www.sease.io > -- > View this message in context: http://lucene.472066.n3. > nabble.com/prefix-facet-performance-tp4330684p4331221.html > Sent from the Solr - User mailing list archive at Nabble.com. >
