Re: Help with a slow filter query

2014-10-07 Thread Mikhail Khludnev
https://cwiki.apache.org/confluence/display/solr/Other+Parsers#OtherParsers-FunctionRangeQueryParser http://lucene.apache.org/solr/4_10_0/solr-core/org/apache/solr/search/FunctionRangeQParserPlugin.html re "this syntax" https://cwiki.apache.org/confluence/display/solr/Local+Parameters+in+Queries O

Re: Help with a slow filter query

2014-10-07 Thread heaven
The syntax for frange query parser is weird: {!frange cache=false cost=200 l=2001-01-01T00:00:00Z u=2013-12-01T23:59:59Z}nominated_at_d or simply {!frange cache=false cost=200 u=2013-12-01T23:59:59Z}nominated_at_d And I don't see any docs in Solr wiki explaining this syntax, these examples above I

Re: Help with a slow filter query

2014-09-23 Thread Mikhail Khludnev
> > 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

Re: Help with a slow filter query

2014-09-11 Thread heaven
Fields: Schema: http://pastie.org/pastes/9544427/text?key=974npslxxalvewhlyc4mg Query debug output: http://pastie.org/pastes/9544433/text?key=v9favzj2ulcaq