lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erik Hatcher <erik.hatc...@gmail.com>
Subject Re: Solr Expression Slow
Date Mon, 12 Feb 2018 18:23:48 GMT
I suggest applying that logic at index time and build yourself a SORT_CRITERIA field and use
that rather than that sophisticated function that looks like it could collapse down to a single
index-time field.

	Erik


> On Feb 12, 2018, at 10:32 AM, ~$alpha` <lavesh.rawat@gmail.com> wrote:
> 
> In the below Solr query I am sorting based on the below expression.
> 
>> sum(if(and(tf(CRITERIA1_FILTER,Y),if(tf(PARTNER_CRITERIA1,N),0,1)),1,0),if(and(tf(CRITERIA2_FILTER,Y),if(tf(PARTNER_CRITERIA2,1),0,1)),1,0))
>> asc
> 
> I have mentioned PARTNER_CRITERIA1 and PARTNER_CRITERIA2 in the expression.
> I have similar10 expression like this.
> 
> I want to remove expression as it is slow,
> Is it better to use custom sorting for such case and if yes, can someone
> help how to do so?
> 
> 
> 
> 
> 
> --
> Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html


Mime
View raw message