I've around 500,000 documents uploaded on elasticsearch cloud (free trial plan) instance. 1GB ram 1 vcpu.
I'm evaluating the search performance and in general I saw:
In the worst case if the keyword I'm searching is frequently the search need around 2 sec.
In the best case the search need 200 milliseconds.
I need performance around 100 milliseconds.
Maybe I've this results because the elasticsearch is far for my pc and there are network delay.
Do you think is good Idea to install local instance on my pc to make those kind of tests?