Please help me with good configuration for the cluster to improve the performance.
My requirement was :-
we are using Cluster 7.9.1
We have an employee table which has around 30 columns and total records in this table are around 30million records. select * from employee where id= '12345'; QueryBuilders.matchQuery("id", "12345"); or QueryBuilders.termQuery("id.keyword", "12345");
I have used matchquery /termquery to replace above query in my API..but using both didnt have much difference.
If the above implementation is good , should we check on the configuration side to increase performance
To hold some n million/billion of records. ( Around 50-60GB) what should be the 1. configuration of cluster, 2. number of nodes, 3. what is the heap memory, 4. CPU Cores ? 5. Number of shard in index ? 6. Do we need to use replicas in index ?
Preformatted text``Preformatted text