Re: JSON facet performance for aggregations

2017-05-25 Thread Saman Rasheed
it will find soothing, somthing, everything each with their number of occurences for the document? thanks, ~ From: Yonik Seeley <ysee...@gmail.com> Sent: 24 May 2017 10:45 To: solr-user@lucene.apache.org Subject: Re: JSON

Re: JSON facet performance for aggregations

2017-05-24 Thread Yonik Seeley
On Mon, May 8, 2017 at 11:27 AM, Yonik Seeley wrote: > I opened https://issues.apache.org/jira/browse/SOLR-10634 to address > this performance issue. OK, this has been committed. A quick test shows about a 30x speedup when faceting on a string/numeric docvalues field with 100K

Re: JSON facet performance for aggregations

2017-05-08 Thread Yonik Seeley
Do you recommend streaming at that case? > > Please advise. > > Thanks > Mikhail > > -Original Message- > From: Yonik Seeley [mailto:ysee...@gmail.com] > Sent: Sunday, May 07, 2017 6:25 PM > To: solr-user@lucene.apache.org > Subject: Re: JSON facet perform

RE: JSON facet performance for aggregations

2017-05-08 Thread Mikhail Ibraheem
recommend streaming at that case? Please advise. Thanks Mikhail -Original Message- From: Yonik Seeley [mailto:ysee...@gmail.com] Sent: Sunday, May 07, 2017 6:25 PM To: solr-user@lucene.apache.org Subject: Re: JSON facet performance for aggregations OK, so I think I know what's going

Re: JSON facet performance for aggregations

2017-05-07 Thread Yonik Seeley
. > > Thanks > Mikhail > > -Original Message- > From: Yonik Seeley [mailto:ysee...@gmail.com] > Sent: Sunday, April 30, 2017 1:04 PM > To: solr-user@lucene.apache.org > Subject: Re: JSON facet performance for aggregations > > It is odd there would be quite su

RE: JSON facet performance for aggregations

2017-04-30 Thread Mikhail Ibraheem
type:terms, > limit:-1, > field:" studentId " > >} > } > > > Thanks > > > -Original Message- > From: Vijay Tiwary [mailto:vijaykr.tiw...@gmail.com] > Sent: Sunday, April 30, 2017 10:44 AM > To: solr-user@lucene.apache.org

Re: JSON facet performance for aggregations

2017-04-30 Thread Yonik Seeley
es in good time 60ms: > > json.facet={ >studentId:{ > type:terms, > limit:-1, > field:" studentId " > >} > } > > > Thanks > > > -Original Message- > From: Vijay Tiwary [mailto:vijaykr.tiw...@gmail.com]

RE: JSON facet performance for aggregations

2017-04-30 Thread Mikhail Ibraheem
- From: Vijay Tiwary [mailto:vijaykr.tiw...@gmail.com] Sent: Sunday, April 30, 2017 10:44 AM To: solr-user@lucene.apache.org Subject: RE: JSON facet performance for aggregations Please enable doc values and try. There is a bug in the source code which causes json facet on string field to run

RE: JSON facet performance for aggregations

2017-04-30 Thread Vijay Tiwary
: solr-user@lucene.apache.org > Subject: Re: JSON facet performance for aggregations > > Json facet on string fields run lot slower than on numeric fields. Try and > see if you can represent studentid as a numeric field. > > On Apr 30, 2017 1:19 PM, "Mikhail Ibraheem" <

RE: JSON facet performance for aggregations

2017-04-30 Thread Mikhail Ibraheem
@lucene.apache.org Subject: Re: JSON facet performance for aggregations Json facet on string fields run lot slower than on numeric fields. Try and see if you can represent studentid as a numeric field. On Apr 30, 2017 1:19 PM, "Mikhail Ibraheem" <mikhail.ibrah...@oracle.com> wrote: >

Re: JSON facet performance for aggregations

2017-04-30 Thread Vijay Tiwary
Json facet on string fields run lot slower than on numeric fields. Try and see if you can represent studentid as a numeric field. On Apr 30, 2017 1:19 PM, "Mikhail Ibraheem" wrote: > Hi, > > I am trying to do aggregation with JSON faceting but performance is very >

JSON facet performance for aggregations

2017-04-30 Thread Mikhail Ibraheem
Hi, I am trying to do aggregation with JSON faceting but performance is very bad for one of the requests: json.facet={ studentId:{ type:terms, limit:-1, field:"studentId", facet:{ x:"sum(grades)" } } }