Hi Kevin, Right, it's the very frequent commits, most likely. Change commits to, say, every 60 or 120 seconds and compare the performance. I think you guys use SPM, so check the Cache graphs (hit % specifically) before and after the above change.
Otis -- Search Analytics - http://sematext.com/search-analytics/index.html Performance Monitoring - http://sematext.com/spm/index.html On Mon, Oct 8, 2012 at 6:09 PM, kevinlieb <ke...@politear.com> wrote: > Thanks for all the replies. > > I oversimplified the problem for the purposes of making my post small and > concise. I am really trying to find the counts of documents by a list of 10 > different authors that match those keywords. Of course on looking up a > single author there is no reason to do a facet query. To be clearer: > Find all documents that contain the word "dude" or "thedude" or > "anotherdude" and count how many of these were written by "eldudearino" and > "zeedudearino" and "adudearino" and "beedudearino" > > I tried facet.query as well as facet.method=fc and neither really helped. > > We are constantly adding documents to the solr index and committing, every > few seconds, which is probably why this is not working well. > > Seems we need to re-architect the way we are doing this... > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Funny-behavior-in-facet-query-on-large-dataset-tp4012584p4012610.html > Sent from the Solr - User mailing list archive at Nabble.com.