[
https://issues.apache.org/jira/browse/SOLR-17699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17934514#comment-17934514
]
David Smiley commented on SOLR-17699:
-------------------------------------
When you tried just the {{frange}} alone in a fq and said it was fast, did you
disable the cache on it as well with {{{}cache=false{}}}?
Frange is a little special in that it is a so-called "PostFilter" in Solr,
which activates when it's by itself in a filter query. It's fairly efficient,
only needing to process the documents that passed through the rest of the
search (whatever that is). But if it's *not* by itself, then ideally it
wouldn't make much difference... but... okay I see a bug; I'll post a small fix
soon
> 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.6.1
> Reporter: Puneet Sharma
> Priority: Major
>
> 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]
