How to speed the hits showing in kibana window

See more:

Kibana

i am importing my sql work bench record into elastic search using log stash

in my sql table 22 Lakhs record will be there

First i run the elastic search 5.6.4
Second i run the kibana 5.6.4
Third i run the log stash 5.6.4

when i run in log stash 5.6.4, from my SQL table record is displaying.

In kibana, discover tab window when i click refresh button record hits show in the top of kibana window 6.403 hits.

when i click refresh button record will refresh and display.

but it is displaying slowly.

how to improve the performance in kibana.

What I have tried:

i am importing mysql work bench record into elastic search using logstash

in mysql table 22 Lakhs record will be there

First i run the elastic search 5.6.4
Second i run the kibana 5.6.4
Third i run the log stash 5.6.4

when i run in log stash 5.6.4, from my sql table record is displaying.

In kibana, discover tab window when i click refresh button record hits show in the top of kibana window 6.403 hits.

when i click refresh button record will refresh and display.

but it is displaying slowly.

how to improve the performance in kibana