Thanks Mike.
It seems like Solr 8 is using different parsing
*Solr6*
<str name="rawquerystring">{!boost
b=sum(scale(PeopleTotalSD,1,2),scale(AssignmentsTotalSD,1,2))}((CompanyTypeSFD:("Private
Company") OR ((CompNameFreeTextS:(BASF ))^0.5 OR (CompAliasFreeTextS:(BASF
))^0.5) OR NationalitySFD:(Algeria) OR
CompWebS:(http\:\/\/newCompanyWebsite)) AND ((*:*
-CompanyStatusSFD:("\*\*\*System Delete\*\*\*")) AND type_level:(parent)))</
str> <str name="querystring">{!boost
b=sum(scale(PeopleTotalSD,1,2),scale(AssignmentsTotalSD,1,2))}((CompanyTypeSFD:("Private
Company") OR ((CompNameFreeTextS:(BASF ))^0.5 OR (CompAliasFreeTextS:(BASF
))^0.5) OR NationalitySFD:(Algeria) OR
CompWebS:(http\:\/\/newCompanyWebsite)) AND ((*:*
-CompanyStatusSFD:("\*\*\*System Delete\*\*\*")) AND type_level:(parent)))</
str> <str name="parsedquery">BoostedQuery(boost(+(CompanyTypeSFD:Private
Company ((CompNameFreeTextS:basf)^0.5 (CompAliasFreeTextS:basf)^0.5)
NationalitySFD:Algeria CompWebS:http://newcompanywebsite) +(+(*:*
-CompanyStatusSFD:***System Delete***)
+type_level:parent),sum(scale(int(PeopleTotalSD),1.0,2.0),scale(int(AssignmentsTotalSD),1.0,2.0))))
</str> <str name="parsedquery_toString">boost(+(CompanyTypeSFD:Private
Company ((CompNameFreeTextS:basf)^0.5 (CompAliasFreeTextS:basf)^0.5)
NationalitySFD:Algeria CompWebS:http://newcompanywebsite) +(+(*:*
-CompanyStatusSFD:***System Delete***)
+type_level:parent),sum(scale(int(PeopleTotalSD),1.0,2.0),scale(int(AssignmentsTotalSD),1.0,2.0)))
</str>
*Solr 8*
<str name="rawquerystring">{!boost
b=sum(scale(PeopleTotalSD,1,2),scale(AssignmentsTotalSD,1,2))}((CompanyTypeSFD:("Private
Company") OR ((CompNameFreeTextS:(BASF ))^0.5 OR (CompAliasFreeTextS:(BASF
))^0.5) OR NationalitySFD:(Algeria) OR
CompWebS:(http\:\/\/newCompanyWebsite)) AND ((*:*
-CompanyStatusSFD:("\*\*\*System Delete\*\*\*")) AND type_level:(parent)))</
str> <str name="querystring">{!boost
b=sum(scale(PeopleTotalSD,1,2),scale(AssignmentsTotalSD,1,2))}((CompanyTypeSFD:("Private
Company") OR ((CompNameFreeTextS:(BASF ))^0.5 OR (CompAliasFreeTextS:(BASF
))^0.5) OR NationalitySFD:(Algeria) OR
CompWebS:(http\:\/\/newCompanyWebsite)) AND ((*:*
-CompanyStatusSFD:("\*\*\*System Delete\*\*\*")) AND type_level:(parent)))</
str> <str
name="parsedquery">FunctionScoreQuery(FunctionScoreQuery(+(CompanyTypeSFD:Private
Company ((CompNameFreeTextS:basf)^0.5 (CompAliasFreeTextS:basf)^0.5)
NationalitySFD:Algeria CompWebS:http://newcompanywebsite) +(+(*:*
-CompanyStatusSFD:***System Delete***) +type_level:parent), scored by
boost(sum(scale(int(PeopleTotalSD),1.0,2.0),scale(int(AssignmentsTotalSD),1.0,2.0)))))
</str> <str
name="parsedquery_toString">FunctionScoreQuery(+(CompanyTypeSFD:Private
Company ((CompNameFreeTextS:basf)^0.5 (CompAliasFreeTextS:basf)^0.5)
NationalitySFD:Algeria CompWebS:http://newcompanywebsite) +(+(*:*
-CompanyStatusSFD:***System Delete***) +type_level:parent), scored by
boost(sum(scale(int(PeopleTotalSD),1.0,2.0),scale(int(AssignmentsTotalSD),1.0,2.0))))
</str>
On Wed, 6 Apr 2022 at 16:31, Mike Drob <md...@mdrob.com> wrote:
> Can you try running with debug=query to see if the two are getting parsed
> differently?
>
> On Wed, Apr 6, 2022 at 8:26 AM Sergio García Maroto <marot...@gmail.com>
> wrote:
>
> > Forgot to mention.
> > Solr 8 = 5 seconds
> > Solr 6 = 1 second
> >
> > On Wed, 6 Apr 2022 at 14:58, Sergio García Maroto <marot...@gmail.com>
> > wrote:
> >
> > > Hi,
> > >
> > > I am in the process of upgrading Solr 6.6.1 to Solr 8.10.1.
> > > In general performance it´s almost the same or even a bit better when
> > > running performance load testing.
> > >
> > > There is a particular scenario where I see an important degradation.
> > > That´s when I boost results base on a function. I boost results based
> on
> > > two fields.
> > > If I take the this part out both Solr 8 and Solr 6 are same
> > performance. *{!boost
> > > b=sum(scale(PeopleTotalSD,1,2),scale(AssignmentsTotalSD,1,2))}*
> > > Both servers have identical machines and data. Actually results coming
> > > back are the same number.
> > >
> > > q={!boost
> > >
> >
> b=sum(scale(PeopleTotalSD,1,2),scale(AssignmentsTotalSD,1,2))}((CompanyTypeSFD:("Private
> > > Company") OR ((CompNameFreeTextS:(kaiku))^0.5 OR
> > > (CompAliasFreeTextS:(kaiku))^0.5) OR NationalitySFD:(Algeria) OR
> > > CompWebS:(http\:\/\/newCompanyWebsite)) AND ((*:*
> > > -CompanyStatusSFD:("\*\*\*System Delete\*\*\*")) AND
> > > type_level:(parent)))&start=0&rows=7&fl=CompanyID&sort=score desc
> > >
> > > Any ideas if this is for some reason?
> > >
> > > Regards,
> > > Sergio
> > >
> >
>
