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...@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