> > when created_at_d:[* TO > 2014-09-08T23:59:59Z] takes 15 seconds. What do I do wrong? >
Nothing serious, you just send darn expensive range. Filter evaluation costs a sum of enumerating terms and enumerating docs under that range. To speed it up: you can reduce the number of terms by dropping some precision in index time: 2014-09-08T23:59:59Z*/MINUTES* see https://cwiki.apache.org/confluence/display/solr/Working+with+Dates if you can drop it, try to it in range query, filter cache will be much more efficient. It will be till expensive, but cached well. another way to deal with range apply it purely as a post filter, use frange and cost > 100. see expensive filter http://heliosearch.org/advanced-filter-caching-in-solr/ On Thu, Sep 11, 2014 at 4:29 PM, heaven <aheave...@gmail.com> wrote: > Fields: > <http://lucene.472066.n3.nabble.com/file/n4158178/Screenshot_836.png> > <http://lucene.472066.n3.nabble.com/file/n4158178/Screenshot_837.png> > > Schema: > http://pastie.org/pastes/9544427/text?key=974npslxxalvewhlyc4mg > > Query debug output: > http://pastie.org/pastes/9544433/text?key=v9favzj2ulcaq0qvorda > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Help-with-a-slow-filter-query-tp4158159p4158178.html > Sent from the Solr - User mailing list archive at Nabble.com. > -- Sincerely yours Mikhail Khludnev Principal Engineer, Grid Dynamics <http://www.griddynamics.com> <mkhlud...@griddynamics.com>
