Faceting at that scale takes time to "warm up". If you've got your caches and
such configured appropriately, then successive searches will be very fast,
however you'll still need to do the cache warming (depends on the faceting
implementation you're using, in this case you're probably using the FieldCache).
Faceting performance doesn't depend on the filters or query.... the caches that
need to be built are indeed across the entire index.
Erik
On Oct 8, 2012, at 16:26 , kevinlieb wrote:
> I am doing a facet query in Solr (3.4) and getting very bad performance.
> This is in a solr shard with 22 million records, but I am specifically doing
> a small time slice. However even if I take the time slice query out it
> takes the same amount of time, so it seems to be searching the entire data
> set.
>
> I am trying to find all documents that contain the word "dude" or "thedude"
> or "anotherdude" and count how many of these were written by "eldudearino"
> (of course names are changed here to protect the innocent...).
>
> My query is like this:
>
> http://myserver:8080/solr/select/?fq=created_at:NOW-5MINUTES&q=(+(text:(%22dude%22+%22thedude%22+%22%23anotherdude%22))+)&facet=true&indent=on&facet.mincount=1&wt=xml&version=2.2&rows=0&fl=author_username,author_id&facet.field=author_username&fq=author_username:(%22@eldudearino%22)
>
> Any ideas what I could be doing wrong?
>
> Thanks in advance!
>
>
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Funny-behavior-in-facet-query-on-large-dataset-tp4012584.html
> Sent from the Solr - User mailing list archive at Nabble.com.
