Hi, just a general question as I was unable to find any old posts relating to stats/percentile/facets performance/cache settings.
I have been using Solr since version 4.0 , now using the latest v. 5.2.1. What I have done: - Increase heap memory to 30gb - Experimented with the cache settings - Merged segments - Used docvalues as filter - Tried with ramdrive for index as well -The field I calculate percentile on is type int, seems to be a big performance difference between int and float/decimal etc. The database consists of multiple sets with 5 mil rows I calculate facets stats for a field filtered by those sets. My fields are indexed not stored The queries are basic curl http://localhost:8983/solr/demo/query -d 'rows=0&fq=set_id:id_of_set&q=*:*& json.facet={ by_something:{terms:{ field:myfield, facet:{ median_value:"percentile(myvalue_field,50)" } }} } As a quick fix I created a cache in redis ;) -Håvard On Sat, Aug 15, 2015 at 10:26 PM, Erick Erickson <erickerick...@gmail.com> wrote: > You have to provide a lot more info about your problem, including > what you've tried, what your data looks like, etc. > > You might review: > http://wiki.apache.org/solr/UsingMailingLists > > Best, > Erick > > On Sat, Aug 15, 2015 at 10:27 AM, Håvard Wahl Kongsgård > <haavard.kongsga...@gmail.com> wrote: > > Hi, I have tried various options to speed up percentile calculation for > > facets. But the internal solr cache only speed up my queries from 22 to > 19 > > sec. > > > > I'am using the new json facets http://yonik.com/json-facet-api/ > > > > Any tips for caching stats? > > > > > > -Håvard >
