Hi Team,
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 ?
Thanks,
Naveena.
Thanks,Preformatted text``Preformatted text