Kinana error:Your query is taking time

Hello All,

I am trying to fetch the aggregation data of around 20000 records and visual I'm using is data table.
I'm teasting in test server with 8 core cpus and with jvm size of 8GB.
Can someone help me understand why its taking around 30 senconds to fetch data,is it becoz its single node elastic and jvm is too low?
Will increasing the no of nodes will fetch this aggregatable data fast?

I'm getting fields value using top hit aggrgation of around 20 fields and bucketing it with size 10000,Would like to understand if this size is increased say 50000 and no of elastic nodes are incraesed with good ram and cpu.will I be able to fetch the data fast?

Intention is to fetch data fast as its done in discover.

Thanks

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