# Does Index/Shard size affects the performance of search/insert/update query?

**URL:** <https://discuss.elastic.co/t/does-index-shard-size-affects-the-performance-of-search-insert-update-query/264878>\
**Category:** Elasticsearch\
**Created:** [February 19, 2021, 3:49pm UTC](https://discuss.elastic.co/t/does-index-shard-size-affects-the-performance-of-search-insert-update-query/264878 "2021-02-19T15:49:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nikunj210903](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nikunj210903/32/84241_2.png) [@Nikunj210903](https://discuss.elastic.co/u/Nikunj210903)\
**Post date:** [February 19, 2021, 3:49pm UTC](https://discuss.elastic.co/t/does-index-shard-size-affects-the-performance-of-search-insert-update-query/264878/1 "2021-02-19T15:49:41Z")

</div>

Does Index/Shard size affects the performance of search/create/update query? So suppose I have 2 indexes. In one index I have 2 GB data and in another index I have 10 GB data. If I fire same search/insert/update query on both the indexes then performance of both query will be same? Or the index which have 10 GB data will take more time that the index which have 2 GB data?

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [February 22, 2021, 12:45am UTC](https://discuss.elastic.co/t/does-index-shard-size-affects-the-performance-of-search-insert-update-query/264878/2 "2021-02-22T00:45:05Z")

</div>

TLDR yes.  
Longer answer, it depends, and if you want to have a definitive answer based on your usage pattern you should test.

---

<div class="post-metadata">

**Author:** ![Nikunj210903](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nikunj210903/32/84241_2.png) [@Nikunj210903](https://discuss.elastic.co/u/Nikunj210903)\
**Post date:** [February 22, 2021, 3:59am UTC](https://discuss.elastic.co/t/does-index-shard-size-affects-the-performance-of-search-insert-update-query/264878/3 "2021-02-22T03:59:07Z")

</div>

Thanks @warkolm

---

<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:** [March 22, 2021, 3:59am UTC](https://discuss.elastic.co/t/does-index-shard-size-affects-the-performance-of-search-insert-update-query/264878/4 "2021-03-22T03:59:36Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.