Hi Ganesh, In general it shouldn't be an issue if you execute sum queries every other hour but you may want to share your cluster configuration (solr version, solr cloud?, # machines, machine configuration, index size) and load(indexing & query load) and perform some tests.
Also FYI, there is streaming/sql functionality available in latest Solr (6.0 above) which are capable of performing these aggregations etc. in parallel(map-reduce way). Thanks, Susheel On Sun, Oct 23, 2016 at 3:14 AM, Ganesh M <mgane...@live.in> wrote: > Is anyone tried summation of numeric field with 10k to 100k documents very > frequently and faced any performance issues ? > Pls share your experience. > > On Sun 23 Oct, 2016 12:27 am Ganesh M, <mgane...@live.in<mailto:mgane > s...@live.in>> wrote: > Hi, > We will have 10K documents for every hour. We would like to find sum on > one field f1 based on certain condition and sum it based on group by > another field f2 > What will be the performance of it ? When this summation happens there > could be other queries coming from other concurrent users. > > I am planning to do summing using following statement > > http://localhost:8983/solr/query?q=*:*& > json.facet={x:'sum(price)'} > > How far is this operation is costly. Can we execute this for every hour > for 10k documents? > > Regards, > Ganesh > >