Performance Degradation with High Query Time in Solr When Using OR with frange in filter query

2025-03-15 Thread Daxesh Parmar
Hi Team,High Query Time in Solr When Using OR with frange in fq We are experiencing high query times in Solr when using an fq filter that combines an OR condition with frange. The response time significantly increases compared to queries that do not use this combination. Query Example fq={!cache=

Performance Degradation in Solr When Using OR with frange in fq

2025-03-12 Thread Daxesh Parmar
Hi Team, High Query Time in Solr When Using OR with frange in fq We are experiencing high query times in Solr when using an fq filter that combines an OR condition with frange. The response time significantly increases compared to queries that do not use this combination. Query Example fq={!cach

Re: Usage of functional sort

2025-03-04 Thread Daxesh Parmar
thank you for the suggestion! On Tue, 4 Mar 2025 at 18:46, Daxesh Parmar wrote: > I have tried it and its working fine in a single sort > > *if(eq(id,"id-1"),3,if(eq(id,"id-2"),2,if(eq(id,"id-1"),1,0))) desc* > > On Tue, 4 Mar 2025 at 18:02, u

Re: Usage of functional sort

2025-03-04 Thread Daxesh Parmar
,"id2"),1,0)) instead? > > — > > > On Mar 4, 2025, at 21:25, Daxesh Parmar > wrote: > > if(eq(id,"id1"),2,0) > >

Usage of functional sort

2025-03-04 Thread Daxesh Parmar
Hello, We are using solr 9, we have a field id, our use case is like this If I have some ids to sort, suppose it has Id1, id2, id3, id4 The solr sorting should be id1 > id2 > id3 > id4 > any other documents in solr. We don't have a defining field that I can index and use the sorting functionalit

Solr Query to Get Unique records plus backFill.

2022-09-22 Thread Daxesh Parmar
If we want to get the unique value in results based on certain field than we can do a collapse on the field and Get the result based on the sort we provide. let say I want to fetch X number of results, for those what I need is 1. Get all the unique values 2. If records are less than X, then fetch

Re: Which method is more performant? SubQueries or Collapsing the results?

2022-09-22 Thread Daxesh Parmar
:15 PM Mikhail Khludnev wrote: > Hi, Daxesh. > Subqueries handle only a single result page, at contrast, collapse should > count the total number of groups (I suppose). > I can say that subquery implementation is far from being performant. > > On Wed, Sep 21, 2022 at 7:41 AM Daxe

Which method is more performant? SubQueries or Collapsing the results?

2022-09-20 Thread Daxesh Parmar
Hii, Can anyone pls provide documentation for internal working of solr Subqueries. and also if we compare the same with collapse and expand queries, which one is efficient in terms of response time and performance.

Re: MultiLevel Collapse Supproted by Solr?

2022-09-07 Thread Daxesh Parmar
and on. > > Collapse will support more than one collapse with versions Solr 8.5+. > > Joel Bernstein > http://joelsolr.blogspot.com/ > > > On Tue, Sep 6, 2022 at 8:29 AM Daxesh Parmar > wrote: > > > Hii, I wanted to know whether solr provides a feature to

MultiLevel Collapse Supproted by Solr?

2022-09-06 Thread Daxesh Parmar
Hii, I wanted to know whether solr provides a feature to do a second collapse on expanded results or not? For my use case I am doing collapse of fieldA, and getting expandedResults. I need the expanded results in such a way that all the values under fieldB are present in expandedResults. Eg. I am