# Elastic query incremental problems

**URL:** <https://discuss.elastic.co/t/elastic-query-incremental-problems/101280>\
**Category:** Elasticsearch\
**Created:** [September 21, 2017, 7:48am UTC](https://discuss.elastic.co/t/elastic-query-incremental-problems/101280 "2017-09-21T07:48:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![NorkG](https://avatars.discourse-cdn.com/v4/letter/n/d07c76/32.png) [@NorkG](https://discuss.elastic.co/u/NorkG)\
**Post date:** [September 21, 2017, 7:48am UTC](https://discuss.elastic.co/t/elastic-query-incremental-problems/101280/1 "2017-09-21T07:48:08Z")

</div>

Hello guys, I'm facing strange problem with query performance/visualization on two different environments:  
5.0 and 5.6 (hardware is same)

It looks like on my 5.0 ELK stack query runs incrementally, kibana/elastic waits for some time and then gives back result step by step.

![incrementserch](https://us1.discourse-cdn.com/elastic/original/3X/d/4/d4da772f7eb5ffbf8fc45bd26fb021e445b4461d.gif)

 ![Incremental search](https://us1.discourse-cdn.com/elastic/original/3X/7/8/7839861fb9d74456ce76fa164234f7b876f94647.PNG)

Both searches are identical and data is very simillar.  
On 5.4-5.6 (tried both) queries most often runs for longer time, and either spits out result all at once, or gives 30sec time out for query.

![InstantSearch](https://us1.discourse-cdn.com/elastic/original/3X/1/9/1917d78585cba371961404cb00db084eb98f86d6.gif)

 ![instant search](https://us1.discourse-cdn.com/elastic/original/3X/7/c/7ccdebd84e5c527c668aa1b23bc415df67441b5c.PNG)

Can this be related with any performance tuning or custom kibana, elastic options?  
Same behavior even with simple query like all data for past year or so on.  
I suspect on 5.6 kibana queries gets no response for 30 sec and time outs the query, on 5.0 it gets some response from time to time and query runs fine.

Looking for any insights on this!

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [September 23, 2017, 10:34am UTC](https://discuss.elastic.co/t/elastic-query-incremental-problems/101280/2 "2017-09-23T10:34:14Z")

</div>

Is this causing a problem?

Also, we’ve renamed ELK to the Elastic Stack, otherwise Beats feels left out 😉

---

<div class="post-metadata">

**Author:** ![NorkG](https://avatars.discourse-cdn.com/v4/letter/n/d07c76/32.png) [@NorkG](https://discuss.elastic.co/u/NorkG)\
**Post date:** [September 25, 2017, 6:33am UTC](https://discuss.elastic.co/t/elastic-query-incremental-problems/101280/3 "2017-09-25T06:33:48Z")

</div>

Yes, because longer queries times out and shows less performance than those who gives result step by step.

---

<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 23, 2017, 6:33am UTC](https://discuss.elastic.co/t/elastic-query-incremental-problems/101280/4 "2017-10-23T06:33:54Z")

</div>

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