That does seem long, but you haven't provided many details about the fields. Are there 100 docs in your index? 100M docs? 500M docs?
Are you using NOW in appropriately? See: On Fri, May 27, 2016 at 1:32 PM, Jay Potharaju <jspothar...@gmail.com> wrote: > Hi, > I am running filter query(range query) on date fields(high cardinality) and > the performance is really bad ...it takes about 2-5 seconds for it to come > back with response. I am rebuilding the index to have docvalues & tdates > instead of "date" field. But not sure if that will alleviate the problem > because of high cardinality. > > Can I store the date as YYYYMMDD and run range queries on them instead of > date fields? > Is that a good option? > > -- > Thanks > Jay
