# Data table too slow

**URL:** <https://discuss.elastic.co/t/data-table-too-slow/172642>\
**Category:** Kibana\
**Created:** [March 16, 2019, 2:34pm UTC](https://discuss.elastic.co/t/data-table-too-slow/172642 "2019-03-16T14:34:35Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![John\_Guzman](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/john_guzman/32/83587_2.png) [@John\_Guzman](https://discuss.elastic.co/u/John_Guzman)\
**Post date:** [March 16, 2019, 2:34pm UTC](https://discuss.elastic.co/t/data-table-too-slow/172642/1 "2019-03-16T14:34:35Z")

</div>

Hello!

I have this data table visualitation in Kibana, but it takes 6+ mins loading 1 month of data and even crashes my explorer. How is it possible to improve the performance?

I noticed that using date histogram in date fields helps load data faster, but is giving me the date value in other format, any suggestion?

Thanks

 ![DataTable%7D](https://us1.discourse-cdn.com/elastic/original/3X/3/9/39b89a875923c32394860bf435085820500a6588.png)

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [March 20, 2019, 5:10pm UTC](https://discuss.elastic.co/t/data-table-too-slow/172642/2 "2019-03-20T17:10:40Z")

</div>

Curious, why are you splitting by so many different things? This is going to end up creating a row for every different combination of the different things you're splitting by. This isn't something that usually ends up being what you want.

---

<div class="post-metadata">

**Author:** ![John\_Guzman](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/john_guzman/32/83587_2.png) [@John\_Guzman](https://discuss.elastic.co/u/John_Guzman)\
**Post date:** [March 21, 2019, 2:37pm UTC](https://discuss.elastic.co/t/data-table-too-slow/172642/3 "2019-03-21T14:37:03Z")

</div>

I wanted to generate a csv report. So, I "solved" this with the reporting module but I had to change the fields names.  
Thanks

---

<div class="post-metadata">

**Author:** ![zivklara](https://avatars.discourse-cdn.com/v4/letter/z/77aa72/32.png) [@zivklara](https://discuss.elastic.co/u/zivklara)\
**Post date:** [March 25, 2019, 2:18pm UTC](https://discuss.elastic.co/t/data-table-too-slow/172642/4 "2019-03-25T14:18:29Z")

</div>

I have a similar issue, data tables are too slow.  
Currently the limit is 200 rows, more than that, kibana gets stuck.

This means that when I need to look at data in dashboard (not 1 month data, but 1 **night** data), I only see partial info. In order to see more, I'll need to change the range every few mins (which also works slow). this is highly inconvenient.

Is there another table we can use to show more than 200 rows in one datatable without it getting stuck?

---

<div class="post-metadata">

**Author:** ![John\_Guzman](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/john_guzman/32/83587_2.png) [@John\_Guzman](https://discuss.elastic.co/u/John_Guzman)\
**Post date:** [March 28, 2019, 4:52pm UTC](https://discuss.elastic.co/t/data-table-too-slow/172642/5 "2019-03-28T16:52:36Z")

</div>

I dont think so. As i said, the best solution i found was selecting the fields i wanted to see on the discover section and exporting the data as csv. On your case, you don't need to export it.

---

<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:** [April 25, 2019, 4:52pm UTC](https://discuss.elastic.co/t/data-table-too-slow/172642/6 "2019-04-25T16:52:37Z")

</div>

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