Re: Solr Aggregation queries are way slower than Elastic Search

2017-12-12 Thread RAUNAK AGRAWAL
Thanks Yonik and Joel. I will try with JSON Facet API and update the results here. On Tue, Dec 12, 2017 at 10:56 PM, Yonik Seeley wrote: > On Tue, Dec 12, 2017 at 9:17 AM, RAUNAK AGRAWAL > wrote: > > Hi Yonik, > > > > So if the query is fine then I guess even using JSON Facet API will not > > h

Re: Solr Aggregation queries are way slower than Elastic Search

2017-12-12 Thread Yonik Seeley
On Tue, Dec 12, 2017 at 9:17 AM, RAUNAK AGRAWAL wrote: > Hi Yonik, > > So if the query is fine then I guess even using JSON Facet API will not > help me here. As Joel mentioned, it's completely different code than the old stats API. This is a very simple use-case, so if we're slower than ES for s

Re: Solr Aggregation queries are way slower than Elastic Search

2017-12-12 Thread Joel Bernstein
The JSON facet API is a different aggregation implementation. So, it will definitely have different performance characteristics. Joel Bernstein http://joelsolr.blogspot.com/ On Tue, Dec 12, 2017 at 9:17 AM, RAUNAK AGRAWAL wrote: > Hi Yonik, > > So if the query is fine then I guess even using JS

Re: Solr Aggregation queries are way slower than Elastic Search

2017-12-12 Thread RAUNAK AGRAWAL
Hi Yonik, So if the query is fine then I guess even using JSON Facet API will not help me here. Can you suggest me some other idea or further tuning which will help me in reducing the latency? On Tue, Dec 12, 2017 at 7:27 PM, Yonik Seeley wrote: > OK great, so it's definitely not the main query

Re: Solr Aggregation queries are way slower than Elastic Search

2017-12-12 Thread Yonik Seeley
OK great, so it's definitely not the main query (which is just a single term query in this example!) > Also I have looked into the JSON Facet API. If I have to use facets, I will > have to then define 3600 facets in a single query and I guess that would be > also slow. You can ask for any number

Re: Solr Aggregation queries are way slower than Elastic Search

2017-12-12 Thread RAUNAK AGRAWAL
Hi Yonik, As you asked here is the code snippet and the actual solr query. Please have a look. I have included only 104 metrics but like this we can go upto 3600 rollups. Also I have looked into the JSON Facet API. If I have to use facets, I will have to then define 3600 facets in a single query

Re: Solr Aggregation queries are way slower than Elastic Search

2017-12-11 Thread RAUNAK AGRAWAL
Hi Yonik, I will try the JSON Facet API and update here but my hunch is that querying mechanism is not the problem. Rather the problem lies with the solr aggregations. Thanks On Tue, Dec 12, 2017 at 6:31 AM, Yonik Seeley wrote: > I think the SolrJ below uses the old stats component. > Hopefull

Re: Solr Aggregation queries are way slower than Elastic Search

2017-12-11 Thread Yonik Seeley
I think the SolrJ below uses the old stats component. Hopefully the JSON Facet API would be faster for this, but it's not completely clear what the main query here looks like, and if it's the source of any bottleneck rather than the aggregations. What does the generated query string actually look l