# Performance of one query in two index of different size

**URL:** <https://discuss.elastic.co/t/performance-of-one-query-in-two-index-of-different-size/14613>\
**Category:** Elasticsearch\
**Created:** [November 27, 2013, 10:28am UTC](https://discuss.elastic.co/t/performance-of-one-query-in-two-index-of-different-size/14613 "2013-11-27T10:28:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![limac](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/limac/32/3981_2.png) [@limac](https://discuss.elastic.co/u/limac)\
**Post date:** [November 27, 2013, 10:28am UTC](https://discuss.elastic.co/t/performance-of-one-query-in-two-index-of-different-size/14613/1 "2013-11-27T10:28:58Z")

</div>

Hi there,  
Is there any different of query performance in index with different size? I  
mean, if there are two index, one is very small while the other is a pretty  
big one, and both of these two share the same map. The query is to search  
some word in docs indexed in last 10 minutes. If the numbers of hits  
of two query are  
same, in such situation, the performance of query is same or not?

Thanks!

Alan

--  
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/CAPwW3GXWqY7%2BP%2B1TYFJ%3Dt87XsGcTxjdKnVNQYWsyRpSKVgi\_UA%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAPwW3GXWqY7%2BP%2B1TYFJ%3Dt87XsGcTxjdKnVNQYWsyRpSKVgi_UA%40mail.gmail.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![jpountz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jpountz/32/45836_2.png) [@jpountz](https://discuss.elastic.co/u/jpountz)\
**Post date:** [November 27, 2013, 10:58am UTC](https://discuss.elastic.co/t/performance-of-one-query-in-two-index-of-different-size/14613/2 "2013-11-27T10:58:23Z")

</div>

There are too many moving parts to give an accurate answer: smaller indexes  
tend to play better with the filesystem cache, etc. The only way to know is  
to test it on your own hardware. However, on average, I would expect the  
query on the bigger index to be only slightly slower than on the smaller  
one.

--  
Adrien Grand

--  
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/CAL6Z4j7Ym%3DiBNj0Gxdw7K1gpidRRd%3DwkWQoYj-k\_eVcNifwgrg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j7Ym%3DiBNj0Gxdw7K1gpidRRd%3DwkWQoYj-k_eVcNifwgrg%40mail.gmail.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<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, 2:04am UTC](https://discuss.elastic.co/t/performance-of-one-query-in-two-index-of-different-size/14613/3 "2017-07-06T02:04:36Z")

</div>