# Division operation in script field is tooooooo slow

**URL:** <https://discuss.elastic.co/t/division-operation-in-script-field-is-tooooooo-slow/38964>\
**Category:** Elasticsearch\
**Created:** [January 12, 2016, 10:36am UTC](https://discuss.elastic.co/t/division-operation-in-script-field-is-tooooooo-slow/38964 "2016-01-12T10:36:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![zhangke](https://avatars.discourse-cdn.com/v4/letter/z/839c29/32.png) [@zhangke](https://discuss.elastic.co/u/zhangke)\
**Post date:** [January 12, 2016, 10:36am UTC](https://discuss.elastic.co/t/division-operation-in-script-field-is-tooooooo-slow/38964/1 "2016-01-12T10:36:02Z")

</div>

Hi,

Different operations in script field lead to quite different performance. In my environment, the below query cost about 400ms.

```
GET es/_search
{
  "size": 0,
  "aggs": {
    "by_cluster": {
      "terms": {
        "field": "Cluster",
        "size": 10
      },
      "aggs": {
        "by_user": {
          "terms": {
            "field": "User",
            "size": 10
          },
          "aggs": {
            "total_pend": {
              "sum": {
              "field": "Pend Time",
              }
            }
          }
        }
      }
    }
  }
}

```

When I use script field which contains multiplication operation, the similar query cost about 1100ms.

```
GET es/_search
{
  "size": 0,
  "aggs": {
    "by_cluster": {
      "terms": {
        "field": "Cluster",
        "size": 10
      },
      "aggs": {
        "by_user": {
          "terms": {
            "field": "User",
            "size": 10
          },
          "aggs": {
            "total_pend": {
              "sum": {
               "script": "doc['Pend Time'].value * 1000"
              }
            }
          }
        }
      }
    }
  }
}

```

But when I use script field which contains division operation, the similar query cost about 6000ms which is too slow.

```
GET es/_search
{
  "size": 0,
  "aggs": {
    "by_cluster": {
      "terms": {
        "field": "Cluster",
        "size": 10
      },
      "aggs": {
        "by_user": {
          "terms": {
            "field": "User",
            "size": 10
          },
          "aggs": {
            "total_pend": {
              "sum": {
               "script": "doc['Pend Time'].value / 1000",
              }
            }
          }
        }
      }
    }
  }
}

```

I know the division operation costs much than multiplication operation. But I still wonder why the performance difference is so big.

Any way to improve the divison performance in script field?

Thanks for the help.

Ke

---

<div class="post-metadata">

**Author:** ![zhangke](https://avatars.discourse-cdn.com/v4/letter/z/839c29/32.png) [@zhangke](https://discuss.elastic.co/u/zhangke)\
**Post date:** [January 13, 2016, 6:06am UTC](https://discuss.elastic.co/t/division-operation-in-script-field-is-tooooooo-slow/38964/2 "2016-01-13T06:06:22Z")

</div>

Any idea about this issue?

---

<div class="post-metadata">

**Author:** ![rmuir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rmuir/32/44949_2.png) [@rmuir](https://discuss.elastic.co/u/rmuir)\
**Post date:** [January 13, 2016, 8:29pm UTC](https://discuss.elastic.co/t/division-operation-in-script-field-is-tooooooo-slow/38964/3 "2016-01-13T20:29:29Z")

</div>

for the case of integer divide, I think groovy may handle the result as bigdecimal ([http://docs.groovy-lang.org/latest/html/documentation/index.html#integer\_division](http://docs.groovy-lang.org/latest/html/documentation/index.html#integer_division)).

---

<div class="post-metadata">

**Author:** ![zhangke](https://avatars.discourse-cdn.com/v4/letter/z/839c29/32.png) [@zhangke](https://discuss.elastic.co/u/zhangke)\
**Post date:** [January 14, 2016, 6:45am UTC](https://discuss.elastic.co/t/division-operation-in-script-field-is-tooooooo-slow/38964/4 "2016-01-14T06:45:22Z")

</div>

It is the root cause indeed. Thanks for your help:slightly\_smiling:.

---

<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:24pm UTC](https://discuss.elastic.co/t/division-operation-in-script-field-is-tooooooo-slow/38964/5 "2017-07-05T23:24:43Z")

</div>