Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
MIME-Version: 1.0
In-Reply-To: <efd846dd-acfd-6b78-7e4a-26646937d942@gn.apc.org>
References: <efd846dd-acfd-6b78-7e4a-26646937d942@gn.apc.org>
From: Susheel Kumar <susheel2777@gmail.com>
Date: Wed, 31 May 2017 11:43:41 -0400
Message-ID: <CAJuqOKJsygVOuRsouDvFD4ohjOUAhXxLn=ToVuD_NtxmxxyqxQ@mail.gmail.com>
Subject: Re: Grouping and group.facet performance disaster
To: solr-user@lucene.apache.org
Content-Type: multipart/alternative; boundary="94eb2c194754d94a5f0550d3c84e"
archived-at: Wed, 31 May 2017 15:43:48 -0000

--94eb2c194754d94a5f0550d3c84e
Content-Type: text/plain; charset="UTF-8"

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
>

--94eb2c194754d94a5f0550d3c84e--