# Search is very slow on an index with 150million documents

**URL:** https://discuss.elastic.co/t/search-is-very-slow-on-an-index-with-150million-documents/32041
**Category:** Elasticsearch
**Created:** [October 12, 2015, 9:07pm UTC](https://discuss.elastic.co/t/search-is-very-slow-on-an-index-with-150million-documents/32041 "2015-10-12T21:07:49Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Kiran\_Madabhushi](https://avatars.discourse-cdn.com/v4/letter/k/c89c15/32.png) [@Kiran\_Madabhushi](https://discuss.elastic.co/u/Kiran_Madabhushi)
#### Post date: [October 12, 2015, 9:07pm UTC](https://discuss.elastic.co/t/search-is-very-slow-on-an-index-with-150million-documents/32041/1 "2015-10-12T21:07:50Z")

</div>

Hi,  
I am just starting elastic search and I have created an index per day with each index storing around 150million documents.  
Each document is a log line from a test run. The log line has a field for the test run which is a non-analyzed url.  
When I do a filtered query on the index for this field, it takes more than 40 seconds to give me the result. What am I doing wrong? How can I speed this up?

Here is an example format of the log line

filename:line

All the lines has the test-url.

Earlier I indexed each test run into its own index (test-url1 test-url2 as indexes after replacing the special chars). I was creating more than 400 indexes per day and it was not scaling after 15 days. But the search was very fast.

I have 4 nodes in my cluster and each index has 2 shards. Will making it 4 shards help?

---

<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 5, 2017, 11:45pm UTC](https://discuss.elastic.co/t/search-is-very-slow-on-an-index-with-150million-documents/32041/2 "2017-07-05T23:45:17Z")

</div>


