# Query speed advice

**URL:** https://discuss.elastic.co/t/query-speed-advice/33471
**Category:** Elasticsearch
**Created:** [November 1, 2015, 7:44pm UTC](https://discuss.elastic.co/t/query-speed-advice/33471 "2015-11-01T19:44:52Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![voipoclay](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/voipoclay/32/4372_2.png) [@voipoclay](https://discuss.elastic.co/u/voipoclay)
#### Post date: [November 1, 2015, 7:44pm UTC](https://discuss.elastic.co/t/query-speed-advice/33471/1 "2015-11-01T19:44:53Z")

</div>

Hello,

I have two queries that produce results basically in the same amount of time and I think there was more discrepancy in the 1.7 version versus the 2.0. I know filters and queries have been reworked so I was hoping I could get advice as to which one is more "efficient" or neither.

-- option 1

```
POST /siptrace-*/_search
{
   "sort": [
      {
         "line": "asc"
      }
   ],
   "from": "0",
   "size": "1000",
   "query": {
      "filtered": {
         "query": {
            "bool": {
               "must": [
                  {
                     "match": {
                        "callid": "201369922_133976002@192.168.18.110"
                     }
                  }
               ]
            }
         }
      }
   }
}

```

-- option 2

```
POST /siptrace-*/_search
{
   "sort": [
      {
         "line": "asc"
      }
   ],
   "from": "0",
   "size": "1000",
   "query": {
      "filtered": {
         "query": {
            "term": {
               "callid": "201369922_133976002@192.168.18.110"
            }
         }
      }
   }
}

```

Thanks in advance!

---

<div class="post-metadata">

### Author: ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [November 1, 2015, 8:14pm UTC](https://discuss.elastic.co/t/query-speed-advice/33471/2 "2015-11-01T20:14:03Z")

</div>

Filtered queries are deprecated so you should use a bool query with a filter clause IMO.

---

<div class="post-metadata">

### Author: ![voipoclay](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/voipoclay/32/4372_2.png) [@voipoclay](https://discuss.elastic.co/u/voipoclay)
#### Post date: [November 1, 2015, 8:19pm UTC](https://discuss.elastic.co/t/query-speed-advice/33471/3 "2015-11-01T20:19:24Z")

</div>

So like this you mean?

```
POST /siptrace-*/_search
{
   "sort": [
      {
         "line": "asc"
      }
   ],
   "from": "0",
   "size": "1000",
   "query": {
      "bool": {
         "filter": [
            {
               "term": {
                  "callid": {
                     "value": "201369922_133976002@192.168.18.110"
                  }
               }
            }
         ]
      }
   }
}
```

---

<div class="post-metadata">

### Author: ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [November 1, 2015, 8:35pm UTC](https://discuss.elastic.co/t/query-speed-advice/33471/4 "2015-11-01T20:35:43Z")

</div>

Exactly!

---

<div class="post-metadata">

### Author: ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [November 1, 2015, 8:37pm UTC](https://discuss.elastic.co/t/query-speed-advice/33471/5 "2015-11-01T20:37:04Z")

</div>

If possible I would reduce size parameter though but it's not related to your question.

---

<div class="post-metadata">

### Author: ![voipoclay](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/voipoclay/32/4372_2.png) [@voipoclay](https://discuss.elastic.co/u/voipoclay)
#### Post date: [November 1, 2015, 8:50pm UTC](https://discuss.elastic.co/t/query-speed-advice/33471/6 "2015-11-01T20:50:54Z")

</div>

yeah sounds good. I just used that size for testing haha.

Thanks!

---

<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:41pm UTC](https://discuss.elastic.co/t/query-speed-advice/33471/7 "2017-07-05T23:41:26Z")

</div>


