You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Matheo Software <in...@matheo-software.com> on 2021/01/14 13:48:07 UTC

[Solr8.7] Performance of group.ngroups ?

Hi All,

 

I have more than 130 million documents, with an index size of more than
400GB on Solr8.7.

 

I do a simple query and it takes around 1400ms, it’s ok but when I use
ngroups=true, I get an answer in 88sec.

I know it’s because Solr calculates the number of groups on a specific field
but is exist a solution to improve that? An alternate solution?

 

Many thanks,

 

Cordialement, Best Regards

Bruno Mannina

 <http://www.matheo-software.com> www.matheo-software.com

 <http://www.patent-pulse.com> www.patent-pulse.com

Tél. +33 0 970 738 743

Mob. +33 0 634 421 817

 <https://www.facebook.com/PatentPulse> facebook (1)
<https://twitter.com/matheosoftware> 1425551717
<https://www.linkedin.com/company/matheo-software> 1425551737
<https://www.youtube.com/user/MatheoSoftware> 1425551760

 



-- 
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus

Re: [Solr8.7] Performance of group.ngroups ?

Posted by Joel Bernstein <jo...@gmail.com>.
You can try collapse as well.



Joel Bernstein
http://joelsolr.blogspot.com/


On Fri, Jan 15, 2021 at 4:51 AM Bruno Mannina <bm...@free.fr> wrote:

> Hello,
>
>
>
> I found a temporary solution to my problem.
>
>
>
> I do a request without ngroups=true => result is quickly
>
> And just after, I do a simple request with my query and this param:
>
> ….&json.facet={x:"unique(fid)"}
>
> Where the field « fid » is my group field name.
>
>
>
> 88 sec => 3~4 sec for both requests.
>
>
>
> Regards,
>
> Bruno
>
>
>
> De : Matheo Software [mailto:info@matheo-software.com]
> Envoyé : jeudi 14 janvier 2021 14:48
> À : solr-user@lucene.apache.org
> Objet : [Solr8.7] Performance of group.ngroups ?
>
>
>
> Hi All,
>
>
>
> I have more than 130 million documents, with an index size of more than
> 400GB on Solr8.7.
>
>
>
> I do a simple query and it takes around 1400ms, it’s ok but when I use
> ngroups=true, I get an answer in 88sec.
>
> I know it’s because Solr calculates the number of groups on a specific
> field
> but is exist a solution to improve that? An alternate solution?
>
>
>
> Many thanks,
>
>
>
> Cordialement, Best Regards
>
> Bruno Mannina
>
>  <http://www.matheo-software.com> www.matheo-software.com
>
>  <http://www.patent-pulse.com> www.patent-pulse.com
>
> Tél. +33 0 970 738 743
>
> Mob. +33 0 634 421 817
>
>  <https://www.facebook.com/PatentPulse> facebook (1)
> <https://twitter.com/matheosoftware> 1425551717
> <https://www.linkedin.com/company/matheo-software> 1425551737
> <https://www.youtube.com/user/MatheoSoftware> 1425551760
>
>
>
>
>
>
>
> <
> https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai
> gn=sig-email&utm_content=emailclient
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>>
>
>
> Garanti sans virus.
> <
> https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai
> gn=sig-email&utm_content=emailclient
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>>
> www.avast.com
>
>
>
>
>
> --
> L'absence de virus dans ce courrier électronique a été vérifiée par le
> logiciel antivirus Avast.
> https://www.avast.com/antivirus
>

RE: [Solr8.7] Performance of group.ngroups ?

Posted by Bruno Mannina <bm...@free.fr>.
Hello,

 

I found a temporary solution to my problem.

 

I do a request without ngroups=true => result is quickly

And just after, I do a simple request with my query and this param:

….&json.facet={x:"unique(fid)"}

Where the field « fid » is my group field name.

 

88 sec => 3~4 sec for both requests.

 

Regards,

Bruno

 

De : Matheo Software [mailto:info@matheo-software.com] 
Envoyé : jeudi 14 janvier 2021 14:48
À : solr-user@lucene.apache.org
Objet : [Solr8.7] Performance of group.ngroups ?

 

Hi All,

 

I have more than 130 million documents, with an index size of more than
400GB on Solr8.7.

 

I do a simple query and it takes around 1400ms, it’s ok but when I use
ngroups=true, I get an answer in 88sec.

I know it’s because Solr calculates the number of groups on a specific field
but is exist a solution to improve that? An alternate solution?

 

Many thanks,

 

Cordialement, Best Regards

Bruno Mannina

 <http://www.matheo-software.com> www.matheo-software.com

 <http://www.patent-pulse.com> www.patent-pulse.com

Tél. +33 0 970 738 743

Mob. +33 0 634 421 817

 <https://www.facebook.com/PatentPulse> facebook (1)
<https://twitter.com/matheosoftware> 1425551717
<https://www.linkedin.com/company/matheo-software> 1425551737
<https://www.youtube.com/user/MatheoSoftware> 1425551760

 

 


 
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai
gn=sig-email&utm_content=emailclient> 

Garanti sans virus.
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai
gn=sig-email&utm_content=emailclient> www.avast.com 

 



-- 
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus