On 1/13/2015 11:44 AM, David Smith wrote: > I looked at Interval faceting. My required interval is 1 day. I cannot > change that requirement. Unless I am mis-reading the doc, that means to > facet a 10 year range, the query needs to specify over 3,600 intervals ??
I am very ignorant of how the internals work ... but it sounds like the parameters you have chosen are basically making thousands of separate facets, almost all of which will ultimately return zero, and therefore be excluded from the results. If my naive assessment of the situation is even close to accurate, then I think the rest of this paragraph would apply: If we assume that those individual facets are running consecutively, each one would be completing in single-digit-millisecond time to add up to about 25 seconds. If we assume they are running in parallel, that's a LOT of work to handle all at once, and the actual workload might look more like it's consecutive because there aren't enough CPU resources to handle them truly in parallel. I don't know that thousands of facets can be sped up very much. Thanks, Shawn