# Time based rollover vs Time based routing

**URL:** <https://discuss.elastic.co/t/time-based-rollover-vs-time-based-routing/245509>\
**Category:** Elasticsearch\
**Created:** [August 19, 2020, 12:08am UTC](https://discuss.elastic.co/t/time-based-rollover-vs-time-based-routing/245509 "2020-08-19T00:08:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![joropito](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joropito/32/32138_2.png) [@joropito](https://discuss.elastic.co/u/joropito)\
**Post date:** [August 19, 2020, 12:08am UTC](https://discuss.elastic.co/t/time-based-rollover-vs-time-based-routing/245509/1 "2020-08-19T00:08:16Z")

</div>

Hi everyone

I wonder what's better in my use case. A single large index, a time based rollover (monthly maybe) or a time based (monthly) shard routing?

The case 10million documents each month (daily ingestion). Some of them are updates but mostly indexing new ones.  
I have to keep all those documents, no daily cleanup. Also each document have an inmutable timestamp field.

Also, what about merging it daily? The ingestion is done in a daily batch, all at once.

I mostly run aggregations (like 10 fields/conditions) and few searchs.

---

<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:** [August 19, 2020, 12:20am UTC](https://discuss.elastic.co/t/time-based-rollover-vs-time-based-routing/245509/2 "2020-08-19T00:20:10Z")

</div>

You should not use a single big index, or any sort of single index-time based shard routing.

You should use [ILM](https://www.elastic.co/guide/en/elasticsearch/reference/current/ilm-start.html).

---

<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:** [September 16, 2020, 12:20am UTC](https://discuss.elastic.co/t/time-based-rollover-vs-time-based-routing/245509/3 "2020-09-16T00:20:27Z")

</div>

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