[ 
https://issues.apache.org/jira/browse/SOLR-6494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14129109#comment-14129109
 ] 

Hoss Man commented on SOLR-6494:
--------------------------------

Please note the most important part of Erick's comment...

bq. First, please raise issues like this on the user's list...

The user list is the appropriate place to ask questions about how to use 
features, and about performance issues you might be seeing.  The *entire* solr 
user community can help you, instead of the much smaller subset of people who 
track Jira bug reports. 

Please also note the following useful tips for asking for help...
https://wiki.apache.org/solr/UsingMailingLists

Since you haven't provided any details about your schema, fields, fieldtypes, 
or even a full example of what your query looks like (beyond just the fq 
params) it's pretty much impossible to guess why your queries might be slow.

----

To re-iterate: ask questions on the user mailing list, not in the bug tracker.

> Query filters applied in a wrong order
> --------------------------------------
>
>                 Key: SOLR-6494
>                 URL: https://issues.apache.org/jira/browse/SOLR-6494
>             Project: Solr
>          Issue Type: Bug
>    Affects Versions: 4.8.1
>            Reporter: Alexander S.
>
> This query:
> {code}
> {
>   fq: ["type:Award::Nomination"],
>   sort: "score desc",
>   start: 0,
>   rows: 20,
>   q: "*:*"
> }
> {code}
> takes just a few milliseconds, but this one:
> {code}
> {
>   fq: [
>     "type:Award::Nomination",
>     "created_at_d:[* TO 2014-09-08T23:59:59Z]"
>   ],
>   sort: "score desc",
>   start: 0,
>   rows: 20,
>   q: "*:*"
> }
> {code}
> takes almost 15 seconds.
> I have just ≈12k of documents with type "Award::Nomination", but around half 
> a billion with created_at_d field set. And it seems Solr applies the 
> created_at_d filter first going through all documents where this field is 
> set, which is not very smart.
> I think if it can't do anything better than applying filters in the alphabet 
> order it should apply them in the order they were received.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

Reply via email to