# Determine Large Query Search

**URL:** <https://discuss.elastic.co/t/determine-large-query-search/21150>\
**Category:** Elasticsearch\
**Created:** [December 8, 2014, 4:57pm UTC](https://discuss.elastic.co/t/determine-large-query-search/21150 "2014-12-08T16:57:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![SD1](https://avatars.discourse-cdn.com/v4/letter/s/7ea924/32.png) [@SD1](https://discuss.elastic.co/u/SD1)\
**Post date:** [December 8, 2014, 4:57pm UTC](https://discuss.elastic.co/t/determine-large-query-search/21150/1 "2014-12-08T16:57:42Z")

</div>

Hi,

We are currently using Time Series Indexing (per day indexing for some  
types and per week indexing for some types). Our searches are also targeted  
searches meaning we calculate which indices should be searched on based on  
the date range in the query. We have fielddata enabled on fields we do  
aggregations and/or sorting on.

Even after this, whenever we perform search on a wide date range (which  
implies large number of indices), our cluster is still coming down. We are  
using Elasticsearch 1.3.1. One of the optimizations we are looking into is  
to clearing field data cache after performing large query search.

Now my question is, whats the best way to determine whether the search is a  
large query search? Will the number of indices being targeted be a good  
metric to determine this?

Any advice is appreciated.

Thanks,  
Shravanthi

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/c6ecaa37-95c4-46a5-a410-25927e91353c%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/c6ecaa37-95c4-46a5-a410-25927e91353c%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 12:44am UTC](https://discuss.elastic.co/t/determine-large-query-search/21150/2 "2017-07-06T00:44:57Z")

</div>

Closed on July 6, 2017, 12:44am UTC