Re: Grouping and group.facet performance disaster

[Ere Maijala <er...@helsinki.fi>]

While I can't say whether it affects you in this case, Solr 6.4.1 has 
serious performance issues. I'd suggest upgrading to at least 6.4.2.

--Ere

31.5.2017, 14.16, Marek Tichy kirjoitti:
> 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
>

-- 
Ere Maijala
Kansalliskirjasto / The National Library of Finland