[
https://issues.apache.org/jira/browse/SOLR-17699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Smiley resolved SOLR-17699.
---------------------------------
Fix Version/s: 9.9
Resolution: Fixed
> High Query Time in Solr When Using OR with frange in fq
> -------------------------------------------------------
>
> Key: SOLR-17699
> URL: https://issues.apache.org/jira/browse/SOLR-17699
> Project: Solr
> Issue Type: Bug
> Security Level: Public(Default Security Level. Issues are Public)
> Affects Versions: 9.0, 9.6.1
> Reporter: Puneet Sharma
> Priority: Major
> Labels: pull-request-available
> Fix For: 9.9
>
> Time Spent: 50m
> Remaining Estimate: 0h
>
> h3. High Query Time in Solr When Using {{OR}} with {{frange}} in {{fq}}
> I am 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.
> h4. Query Example
>
> {{fq=\{!cache=false tag=prm}field:value OR \{!frange l=1 u=1 v=$funcQuery}}}
> Here, {{$funcQuery}} is a function query that retrieves documents dynamically
> based on dynamic parameters.
> h4. Observations
> * When I use just {{{}{!frange l=1 u=1 v=$funcQuery}{}}}, the query executes
> quickly[20ms].
> * When I use {{{!cache=false tag=prm}field:value}} alone, the query is also
> fast.
> * However, when combining both with {{{}OR{}}}, the query time increases
> significantly [700ms].
> * The dataset is relatively large, but other queries with similar complexity
> run efficiently.
> h4. Questions
> # Why does the {{OR}} operation with {{frange}} cause a significant increase
> in query time?
> # Are there any optimizations or alternative query structures that could
> improve performance?
> # Would it help to restructure how function queries and filters are applied
> in this case?
> # Is there any alternative for frange for this use case because in our use
> case, this cannot be done at index time because the function parameters
> change very frequently?
> Any insights or suggestions would be greatly appreciated!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
