# Search is slow on single machine cluster

**URL:** <https://discuss.elastic.co/t/search-is-slow-on-single-machine-cluster/145880>\
**Category:** Elasticsearch\
**Created:** [August 24, 2018, 9:37am UTC](https://discuss.elastic.co/t/search-is-slow-on-single-machine-cluster/145880 "2018-08-24T09:37:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ashishtiwari1993](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ashishtiwari1993/32/135241_2.png) [@ashishtiwari1993](https://discuss.elastic.co/u/ashishtiwari1993)\
**Post date:** [August 24, 2018, 9:37am UTC](https://discuss.elastic.co/t/search-is-slow-on-single-machine-cluster/145880/1 "2018-08-24T09:37:51Z")

</div>

Hi Team,

ES configuration:

Heap : 30gb  
Ram : 128gb  
Primary shards : 15  
replica : 1  
index : 1  
index size : 200GB  
version : 6.2.2  
single cluster machine, no node

I am performing search query on above index. I am giving date range on field adate which has format 'yyyyMMdd' . Also performing sorting on field 'atime' with format 'yyyy-MM-dd HH:mm:ss'

Here is my query:

```
curl -XPOST 'myhost:9200/index/_search?pretty' -H 'Content-type:application/json' -d '
{
    "query":{
        "bool":{
            "must":[
                {"range":{"adate":{"gte":20180523,"lte":20180823}}}
            ]
        }
    },
    "sort":{"atime":"desc"}
}                            
'

```

I am getting below output which is too slow.

```
{
  "took" : 85322,
  "timed_out" : false,
  "_shards" : {
    "total" : 15,
    "successful" : 15,
    "skipped" : 0,
    "failed" : 0
  }
}

```

Writing is continuous going on . When i stopped the writing i got good performance. But why my reading is slow while writing data?

---

<div class="post-metadata">

**Author:** ![jaddison](https://avatars.discourse-cdn.com/v4/letter/j/e5b9ba/32.png) [@jaddison](https://discuss.elastic.co/u/jaddison)\
**Post date:** [September 10, 2018, 3:32am UTC](https://discuss.elastic.co/t/search-is-slow-on-single-machine-cluster/145880/2 "2018-09-10T03:32:19Z")

</div>

You probably need to show your **mapping(s)**, example document data, number of documents.

However, I think you can switch from `must` to `filter`, which might help a bit (cuts down on scoring, I think? I might be wrong)

---

<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:** [October 8, 2018, 3:32am UTC](https://discuss.elastic.co/t/search-is-slow-on-single-machine-cluster/145880/3 "2018-10-08T03:32:30Z")

</div>

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