[
https://issues.apache.org/jira/browse/SOLR-17699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17934523#comment-17934523
]
David Smiley commented on SOLR-17699:
-------------------------------------
If I had merged SOLR-14164 way back then we wouldn't have seen this problem
since we wouldn't have a code with this bug to maintain. But I wasn't sure if
the change over there might have hurt the typical/standard case. (fq with
frange only).
The bug we have here could could also apply to some numeric range queries
(numeric field with numeric range) where the lower side is less than 0 and
upper side is not.
> 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
> Time Spent: 10m
> 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]
