[
https://issues.apache.org/jira/browse/SOLR-16102?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17508669#comment-17508669
]
Jan Høydahl commented on SOLR-16102:
------------------------------------
Try [Terms
Query|https://solr.apache.org/guide/8_11/other-parsers.html#terms-query-parser]
for more efficient ORing of long lists without underlying BoolQuery, e.g.
{code}
&fq={!terms f=category}foo,bar,baz,boo
{code}
PS: I'll not respond to followup comments, as such discussions should be done
in the support channels :)
> Performance issue with multiple or in fq
> ----------------------------------------
>
> Key: SOLR-16102
> URL: https://issues.apache.org/jira/browse/SOLR-16102
> Project: Solr
> Issue Type: Bug
> Security Level: Public(Default Security Level. Issues are Public)
> Affects Versions: 8.3.1
> Reporter: Kundan
> Priority: Major
>
> I have a requirement where I need to filter results based on multiple
> conditions, and I'm analyzing 100 rows in one request.
> If we get millions of such requests then Solr slows down performance.
> ||Total Solr Records||Number of fields in the document||Total 'OR' condition
> in fq||
> |4402842|13|300+|
> *Why we need these many Or conditions in fq:* We need to analyze production
> from all 300+ categories, out of 700+ categories.
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@solr.apache.org
For additional commands, e-mail: issues-h...@solr.apache.org
