lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Susheel Kumar <susheel2...@gmail.com>
Subject Re: Grouping and group.facet performance disaster
Date Wed, 31 May 2017 15:43:41 GMT
Did you try sub-facets ( http://yonik.com/json-facet-api/ )  if that meets
your facet grouping requirements or try Collapse/Expand Results.
https://cwiki.apache.org/confluence/display/solr/Collapse+and+Expand+Results


Thnx

On Wed, May 31, 2017 at 7:16 AM, Marek Tichy <marek@gn.apc.org> wrote:

> Hi,
>
> I'm getting a very slow response times on grouping, especially on facet
> grouping.
>
> Without grouping, the query takes 14ms, faceting 57ms.
>
> With grouping, the query time goes up to 1131ms, with facet grouping,
> the faceting goes up to the unbearable 12103 ms.
>
> Single solr instance, 927086docs, 518.23 MB size, solr 6.4.1.
>
> Is this really the price of grouping ? Are there any magic
> tricks/tips/techniques to improve the speed ?
> The query params below.
>
> Many thanks for any help, much appreciated.
>
> Best
>  Marek Tichy
>
>
>
>
>
>
>
>
> fq=((type:knihy) OR (type:defekty))
> fl=*
> start=0
> f.ebook_formats.facet.mincount=1
> f.authorid.facet.mincount=1
> f.thematicgroupid.facet.mincount=1
> f.articleparts.facet.mincount=1
> f.type.facet.mincount=1
> f.languageid.facet.mincount=1
> f.showwindow.facet.mincount=1
> f.articletypeid_grouped.facet.mincount=1
> f.languageid.facet.limit=10
> f.ebook_formats.facet.limit=10
> f.authorid.facet.limit=10
> f.type.facet.limit=10
> f.articleparts.facet.limit=10
> f.thematicgroupid.facet.limit=10
> f.articletypeid_grouped.facet.limit=10
> f.showwindow.facet.limit=100
> version=2.2
> group.limit=30
> rows=30
> echoParams=all
> sort=date desc,planneddate asc
> group.field=edition
> facet.method=enum
> group.truncate=false
> group.format=grouped
> group=true
> group.ngroups=true
> stats=true
> facet=true
> group.facet=true
> stats.field={!distinctValues=true}categoryid
> facet.field={!ex=at}articletypeid_grouped
> facet.field={!ex=at}type
> facet.field={!ex=author}authorid
> facet.field={!ex=format}articleparts
> facet.field={!ex=format}ebook_formats
> facet.field={!ex=lang}languageid
> facet.field={!ex=sw}showwindow
> facet.field={!ex=tema}thematicgroupid
> stats.field={!min=true max=true}price
> stats.field={!min=true max=true}yearout
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message