[ https://issues.apache.org/jira/browse/SOLR-6494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14129956#comment-14129956 ]
Alexander S. commented on SOLR-6494: ------------------------------------ Added the schema and debug output here: http://lucene.472066.n3.nabble.com/Help-with-a-slow-filter-query-td4158159.html > 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