# Elasticsearch works slow on Azure **URL:** \ **Category:** Elasticsearch\ **Created:** [April 24, 2018, 6:08pm UTC](https://discuss.elastic.co/t/elasticsearch-works-slow-on-azure/129362 "2018-04-24T18:08:41Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Abhinaw](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@Abhinaw](https://discuss.elastic.co/u/Abhinaw)\ **Post date:** [April 24, 2018, 6:08pm UTC](https://discuss.elastic.co/t/elasticsearch-works-slow-on-azure/129362/1 "2018-04-24T18:08:41Z")
Hi i have deployed elasticsearch on Azure VM with 28GB RAM size. My database size is 100GB . A query which returns 30K result takes more than 3 minutes. many thanks ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [April 24, 2018, 6:20pm UTC](https://discuss.elastic.co/t/elasticsearch-works-slow-on-azure/129362/2 "2018-04-24T18:20:13Z")
what type of query are you running? What type of data are you querying? How many indices and shards are the query targeting? ---
**Author:** ![Abhinaw](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@Abhinaw](https://discuss.elastic.co/u/Abhinaw)\ **Post date:** [April 24, 2018, 6:42pm UTC](https://discuss.elastic.co/t/elasticsearch-works-slow-on-azure/129362/3 "2018-04-24T18:42:01Z")
MY Query looks like this, ``` "query": { "multi_match" : { "query": "honda bike", "type": "cross_fields", "operator": "and", "analyzer":"my_synonyms" } ``` I have reviews in my database, with above query i am trying to find all the reviews where honda and bike both are present. Total indices 1 and 30 shards. ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [April 24, 2018, 6:47pm UTC](https://discuss.elastic.co/t/elasticsearch-works-slow-on-azure/129362/4 "2018-04-24T18:47:52Z")
Which version of Elasticsearch are you using? What type of storage do you have? What does disk I/O and iowait look like while the query is executing? ---
**Author:** ![Abhinaw](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@Abhinaw](https://discuss.elastic.co/u/Abhinaw)\ **Post date:** [April 24, 2018, 6:50pm UTC](https://discuss.elastic.co/t/elasticsearch-works-slow-on-azure/129362/5 "2018-04-24T18:50:52Z")
6.2.3 elasticsearch version. SSD storage ``` Tasks: 159 total, 1 running, 158 sleeping, 0 stopped, 0 zombie %Cpu(s): 0.0 us, 0.0 sy, 0.0 ni, 99.9 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st KiB Mem : 32919076 total, 259524 free, 23101600 used, 9557952 buff/cache KiB Swap: 0 total, 0 free, 0 used. 9219840 avail Mem ``` ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [April 24, 2018, 6:52pm UTC](https://discuss.elastic.co/t/elasticsearch-works-slow-on-azure/129362/6 "2018-04-24T18:52:33Z")
Is that the full query you are running? ---
**Author:** ![Abhinaw](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@Abhinaw](https://discuss.elastic.co/u/Abhinaw)\ **Post date:** [April 24, 2018, 6:56pm UTC](https://discuss.elastic.co/t/elasticsearch-works-slow-on-azure/129362/7 "2018-04-24T18:56:25Z")
Yes this is my complete query. ``` "query": { "multi_match" : { "query": "honda bike", "type": "cross_fields", "operator": "and", "analyzer":"my_synonyms" } ``` ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [April 24, 2018, 6:58pm UTC](https://discuss.elastic.co/t/elasticsearch-works-slow-on-azure/129362/8 "2018-04-24T18:58:45Z")
Can you please show us the full request you are sending? ---
**Author:** ![Abhinaw](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@Abhinaw](https://discuss.elastic.co/u/Abhinaw)\ **Post date:** [April 24, 2018, 7:01pm UTC](https://discuss.elastic.co/t/elasticsearch-works-slow-on-azure/129362/9 "2018-04-24T19:01:23Z")
``` GET _search { "query": { "multi_match" : { "query": "honda bike", "type": "cross_fields", "operator": "and", "analyzer":"my_synonyms" } ``` ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [April 24, 2018, 7:04pm UTC](https://discuss.elastic.co/t/elasticsearch-works-slow-on-azure/129362/10 "2018-04-24T19:04:09Z")
That is not valid JSON as there are curly braces missing. Is there anything else that has been left out? Are you specifying size anywhere? How is the `my_synonyms` analyser defined? ---
**Author:** ![Abhinaw](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@Abhinaw](https://discuss.elastic.co/u/Abhinaw)\ **Post date:** [April 24, 2018, 7:19pm UTC](https://discuss.elastic.co/t/elasticsearch-works-slow-on-azure/129362/11 "2018-04-24T19:19:01Z")
``` PUT /test/_settings { "analysis": { "filter": { "my_synonym_filter": { "type": "synonym", "synonyms_path": "synonym.txt" } }, "analyzer": { "my_synonyms": { "tokenizer": "whitespace", "filter": [ "lowercase", "my_synonym_filter" ] } } } } ``` Size is defined 50000 ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [April 24, 2018, 8:27pm UTC](https://discuss.elastic.co/t/elasticsearch-works-slow-on-azure/129362/12 "2018-04-24T20:27:17Z")
How large is the synonyms file? ---
**Author:** ![Abhinaw](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@Abhinaw](https://discuss.elastic.co/u/Abhinaw)\ **Post date:** [April 25, 2018, 6:51am UTC](https://discuss.elastic.co/t/elasticsearch-works-slow-on-azure/129362/13 "2018-04-25T06:51:51Z")
It has almost 5k lines ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 23, 2018, 6:51am UTC](https://discuss.elastic.co/t/elasticsearch-works-slow-on-azure/129362/14 "2018-05-23T06:51:52Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.