I have elasticsearch 5.2 running on a big VM :
128 GB RAM
As mentioned in the documentation , I set Heap to slightly less than half to 60 GB.
The problem : In kibana, I want to display data tables with 80000 lines and 50 columns ( sometimes even more)
the result : either so slow or no result ( I changed timeout conf in kibana).
So recently , I added another node but no major change in performance.
The question : How to improve performance and boost search query speed by any means possible ? ( configurations , hardware ...)