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.