Some mistake in the previous email. Here is the specs of some example query faceting on three fields (all string type): first call: 1+ sec (with docValues) vs. 4+ sec (w/o docValues) subsequent calls: 100+ ms (with docValues) vs. 30+ ms (w/o docValues) consistently the total # of docs returned is around 600,000
The query looks like this: q=*:*&fq=country:"US"&fq=category:112&facet=on&facet.sort=index&facet.mincount=1&facet.limit=2000&facet.field=manufacturer&facet.field=seller&facet.field=material&f.manufacturer.facet.mincount=1&f.manufacturer.facet.sort=count&f.manufacturer.facet.limit=100&f.seller.facet.mincount=1&f.seller.facet.sort=count&f.seller.facet.limit=100&f.material.facet.mincount=1&sort=score+desc Thanks, On Thu, Mar 5, 2015 at 11:42 AM, Mikhail Khludnev < mkhlud...@griddynamics.com> wrote: > Hello, > > I have one consideration on top of my head, would you mind to show a brief > snapshot by a sampler? > > On Thu, Mar 5, 2015 at 10:18 PM, lei <simpl...@gmail.com> wrote: > > > Hi there, > > > > I'm testing facet performance with vs without docValues in Solr 4.7, and > > found that on first request, performance with docValues is much faster > than > > non-docValues. However, for subsequent requests (where the queries are > > cached), the performance is slower for docValues than non-docValues. Is > > this an expected behavior? Any idea or solution is appreciated. Thanks. > > > > > > -- > Sincerely yours > Mikhail Khludnev > Principal Engineer, > Grid Dynamics > > <http://www.griddynamics.com> > <mkhlud...@griddynamics.com> >